UFN_MKTSEED_GETADDRESSEESALUTATION

Returns an addressee or salutation for a seed.

Return

Return Type
nvarchar(255)

Parameters

Parameter	Parameter Type	Mode
@SALUTATION	bit	IN
@TITLE	nvarchar(100)	IN
@FIRSTNAME	nvarchar(100)	IN
@LASTNAME	nvarchar(100)	IN

Definition

Copy



create function dbo.[UFN_MKTSEED_GETADDRESSEESALUTATION]
(
  @SALUTATION bit,
  @TITLE nvarchar(100),
  @FIRSTNAME nvarchar(100),
  @LASTNAME nvarchar(100)
)
returns nvarchar(255)
as
begin
  declare @ADDSAL nvarchar(255);

  if len(ltrim(rtrim(@TITLE))) = 0 set @TITLE = null;
  if len(ltrim(rtrim(@FIRSTNAME))) = 0 set @FIRSTNAME = null;
  if @LASTNAME = null set @LASTNAME = '';

  set @ADDSAL = @LASTNAME;
  if @FIRSTNAME is not null and @SALUTATION = 0 set @ADDSAL = @FIRSTNAME + ' ' + @ADDSAL;
  if @TITLE is not null set @ADDSAL = @TITLE + ' ' + @ADDSAL;

  return @ADDSAL;
end