UFN_CONSTITUENTMARKETING_PRIMARYSALUTATION

Used by the constituent marketing query view to retrieve a primary salutation for a constituent.

Return

Return Type
nvarchar(700)

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@KEYNAME	nvarchar(200)	IN
@FIRSTNAME	nvarchar(100)	IN
@MIDDLENAME	nvarchar(100)	IN
@TITLE	nvarchar(100)	IN
@SUFFIX	nvarchar(100)	IN

Definition

Copy



create function dbo.[UFN_CONSTITUENTMARKETING_PRIMARYSALUTATION]
(
  @CONSTITUENTID uniqueidentifier,
  @KEYNAME nvarchar(200),
  @FIRSTNAME nvarchar(100),
  @MIDDLENAME nvarchar(100),
  @TITLE nvarchar(100),
  @SUFFIX nvarchar(100)
)
returns nvarchar(700)
as
  begin
    declare @SALUTATION nvarchar(700);

    select @SALUTATION =
      case when [NAMEFORMAT].[NAMEFORMATFUNCTIONID] is null
           then [NAMEFORMAT].[CUSTOMNAME]
           else
             case when [NAMEFORMAT].[NAMEFORMATFUNCTIONID] = (select [ID] from dbo.[NAMEFORMATFUNCTION] where [FORMATSQLFUNCTION] = 'UFN_NAMEFORMATFUNCTION_SIMPLE')
             then dbo.[UFN_NAMEFORMATFUNCTION_SIMPLE](@CONSTITUENTID, @KEYNAME, @FIRSTNAME, @MIDDLENAME, @TITLE, @SUFFIX, '', '', '', '', '')
             else dbo.[UFN_NAMEFORMAT_FROMID]([NAMEFORMAT].[NAMEFORMATFUNCTIONID], [NAMEFORMAT].[CONSTITUENTID]) 
           end
      end
    from dbo.[NAMEFORMAT]
    where [NAMEFORMAT].[CONSTITUENTID] = @CONSTITUENTID
    and [NAMEFORMAT].[PRIMARYSALUTATION] = 1;

    return @SALUTATION;
  end