UFN_CONSTITUENTACCOUNT_GETACCOUNTNUMBERINWEBFORMAT

gets a concatenated string that represents a constituent's bank account to display on a web page 'Financial Institution - Account Type -*Last 4 of Account Number'

Return

Return Type
nvarchar(260)

Parameters

Parameter	Parameter Type	Mode
@FINANCIALINSTITUTION	nvarchar(100)	IN
@ACCOUNTNUMBER	nvarchar(50)	IN
@ACCOUNTTYPE	nvarchar(8)	IN

Definition

Copy



            CREATE FUNCTION UFN_CONSTITUENTACCOUNT_GETACCOUNTNUMBERINWEBFORMAT 
          (
              @FINANCIALINSTITUTION nvarchar(100),
              @ACCOUNTNUMBER nvarchar(50),
              @ACCOUNTTYPE nvarchar(8)
          )
          RETURNS nvarchar(260)
          AS
          BEGIN    
                declare @NAMEANDTYPE nvarchar(252);
                declare @TRUNCATEDACCOUNTNUMBER nvarchar(4);
                declare @DESCRIPTION nvarchar(260);

                -- Building the direct debit account in the web format

                -- <Financial Institution> - <Account Type> -* <Last 4 of Account Number>

                set @NAMEANDTYPE = @FINANCIALINSTITUTION + ' - ' + @ACCOUNTTYPE    

                if len(@NAMEANDTYPE) = 3 and @ACCOUNTNUMBER is null 
                    set @DESCRIPTION = '';

                if LEN(@ACCOUNTNUMBER) = 0
                    set @DESCRIPTION = @NAMEANDTYPE    
                else    
                    set @TRUNCATEDACCOUNTNUMBER = SUBSTRING(@ACCOUNTNUMBER, LEN(@ACCOUNTNUMBER) - 3, LEN(@ACCOUNTNUMBER))
                    set @DESCRIPTION = @NAMEANDTYPE + ' - *' + @TRUNCATEDACCOUNTNUMBER;

            RETURN @DESCRIPTION
          END