UFN_BUILDNAMEFORMAT

This function returns a name format based on function ID.

Return

Return Type
nvarchar(700)

Parameters

Parameter	Parameter Type	Mode
@NAMEFORMATFUNCTIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@LASTNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@TITLE	nvarchar(100)	IN
@SUFFIX	nvarchar(100)	IN
@SPOUSELASTNAME	nvarchar(100)	IN
@SPOUSEFIRSTNAME	nvarchar(50)	IN
@SPOUSEMIDDLENAME	nvarchar(50)	IN
@SPOUSETITLE	nvarchar(100)	IN
@SPOUSESUFFIX	nvarchar(100)	IN

Definition

Copy



            CREATE function dbo.UFN_BUILDNAMEFORMAT
            (
                @NAMEFORMATFUNCTIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier, 
                @LASTNAME nvarchar(100),
                @FIRSTNAME nvarchar(50),
                @MIDDLENAME nvarchar(50), 
                @TITLE nvarchar(100),
                @SUFFIX nvarchar(100),
                @SPOUSELASTNAME nvarchar(100), 
                @SPOUSEFIRSTNAME nvarchar(50),
                @SPOUSEMIDDLENAME nvarchar(50), 
                @SPOUSETITLE nvarchar(100),
                @SPOUSESUFFIX nvarchar(100)
            ) 
            returns nvarchar(700) 
            with execute as caller 
            begin
                declare @NAME nvarchar(700)
                select @NAME = dbo.UFN_BUILDNAMEFORMAT_INTERNAL(@NAMEFORMATFUNCTIONID ,@CONSTITUENTID , @LASTNAME ,@FIRSTNAME ,@MIDDLENAME , @TITLE ,@SUFFIX ,@SPOUSELASTNAME , @SPOUSEFIRSTNAME ,@SPOUSEMIDDLENAME , @SPOUSETITLE ,@SPOUSESUFFIX , 0)
                return @NAME;
             end;