UFN_SOLICITCODE_CONSENTONFORCODE

            CREATE function dbo.UFN_SOLICITCODE_CONSENTONFORCODE(@SOLICITCODEID uniqueidentifier)
            returns bit
            with execute as caller
            as begin

            declare @RETURNBIT bit = 0;

            select  @RETURNBIT = 
                    case
                        when CONSENTCODE = 0 then 0
                        else 1
                    end
            from 
                dbo.SOLICITCODE 
            where 
                ID = @SOLICITCODEID;

                return(@RETURNBIT);

            end;