UFN_CONSTITUENTACCOUNT_GETPARTIALACCOUNTNUMBER

gets the partial account number of a constituent's account

Return

Return Type
nvarchar(4)

Parameters

Parameter	Parameter Type	Mode	Description
@ACCOUNTNUMBER	nvarchar(50)	IN

Definition

Copy



            CREATE FUNCTION UFN_CONSTITUENTACCOUNT_GETPARTIALACCOUNTNUMBER 
          (
            @ACCOUNTNUMBER nvarchar(50)
          )
          RETURNS nvarchar(4)
          AS
          BEGIN    
                declare @TRUNCATEDACCOUNTNUMBER nvarchar(4);
                declare @DESCRIPTION nvarchar(260);

                if @ACCOUNTNUMBER is null
                    set @TRUNCATEDACCOUNTNUMBER = ''
                else
                    set @TRUNCATEDACCOUNTNUMBER = SUBSTRING(@ACCOUNTNUMBER, LEN(@ACCOUNTNUMBER) - 3, 4)
            RETURN @TRUNCATEDACCOUNTNUMBER
          END