UFN_DISBURSEMENTPROCESSSIGNATURE_GETDESCRIPTION

            CREATE function dbo.UFN_DISBURSEMENTPROCESSSIGNATURE_GETDESCRIPTION
            (
                @DISBURSEMENTPROCESSID uniqueidentifier,
                @TYPECODE tinyint
            )
            returns nvarchar(max)
            with execute as caller
            as begin
                declare @DESC nvarchar(max);
                select @DESC = substring((
          select
          case when LEN(dbo.UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETRANGE(@DISBURSEMENTPROCESSID, @TYPECODE, FROMAMOUNT)) > 0 
              then 'From $' + cast(ts.FROMAMOUNT as nvarchar) + ' to $' + dbo.UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETRANGE(@DISBURSEMENTPROCESSID, @TYPECODE, FROMAMOUNT)
              else 'Over $' + cast(ts.FROMAMOUNT as nvarchar)
            end + ' use ' + isnull(dbo.UFN_SIGNATURE_USERNAME(S.SIGNERCODE, S.NAME, S.APPUSERID), 'Do not print signature')
                from dbo.DISBURSEMENTPROCESSSIGNATURE TS
                    left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B on TS.BANKACCOUNTAUTHORIZEDSIGNATUREID = B.ID
                    left outer join dbo.SIGNATURE S on B.SIGNATUREID = S.ID
                where TS.DISBURSEMENTPROCESSID = @DISBURSEMENTPROCESSID and TS.TYPECODE = @TYPECODE
                order by TS.FROMAMOUNT
                for XML PATH( '' )), 2, 8000)
                return @DESC
            end