UFN_CONSTITUENTMASKEDACCOUNT_GETDESCRIPTION

create function dbo.UFN_CONSTITUENTMASKEDACCOUNT_GETDESCRIPTION(@ID uniqueidentifier)
            returns nvarchar(254)
            with execute as caller
            as begin
                    declare @INSTITUTIONNAME nvarchar(202);
                    declare @ACCOUNTNUM nvarchar(50);
          declare @MASKEDACCOUNTNUMBER nvarchar(50);

                    select
                        @INSTITUTIONNAME = FINANCIALINSTITUTION.DESCRIPTION,  
                        @ACCOUNTNUM = coalesce(convert(nvarchar(50), DecryptByKey(CONSTITUENTACCOUNT.ACCOUNTNUMBER)),''),
            @MASKEDACCOUNTNUMBER = case when len(@ACCOUNTNUM) = 0 then ''  
              else REPLICATE('x', LEN(@ACCOUNTNUM)- LEN(RIGHT(@ACCOUNTNUM,4))) + RIGHT(@ACCOUNTNUM,4) end            
                    from
                        dbo.CONSTITUENTACCOUNT
                    inner join
                        dbo.FINANCIALINSTITUTION
                    on
                        CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID = FINANCIALINSTITUTION.ID
                    where CONSTITUENTACCOUNT.ID = @ID;

                    if @INSTITUTIONNAME is null and @MASKEDACCOUNTNUMBER is null
                        return '';

                    if len(@MASKEDACCOUNTNUMBER) = 0 
                        return @INSTITUTIONNAME;
                    else
                        return @MASKEDACCOUNTNUMBER + ' (' + @INSTITUTIONNAME + ')';

                    return '';
            end