UFN_CONSTITUENTCREDITCARD_GETCARDINFOINWEBFORMAT

gets a concatenated string that represents a constituent's credit card to display on a web page '*last four - Exp: mo\yr'

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode
@CardPartialNum	nvarchar(4)	IN
@CardExpires	UDT_FUZZYDATE	IN
@CardTypeCodeId	uniqueidentifier	IN
@CardHolderName	nvarchar(255)	IN

Definition

Copy



            CREATE FUNCTION UFN_CONSTITUENTCREDITCARD_GETCARDINFOINWEBFORMAT 
      (
          -- Add the parameters for the function here

          @CardPartialNum nvarchar(4),
          @CardExpires dbo.UDT_FUZZYDATE,
          @CardTypeCodeId uniqueidentifier,
          @CardHolderName nvarchar(255)
      )
      RETURNS nvarchar(MAX)
      AS
      BEGIN
          DECLARE @OutString as nvarchar(MAX)

          SELECT @OutString = '*' + @CardPartialNum + ' - Exp: ' + SUBSTRING(@CardExpires, 5, 2)+ '/' + SUBSTRING(@CardExpires, 3, 2)

          RETURN @OutString

      END