UFN_NAMEFORMATFUNCTION_SIMPLE

A name format function including the prefix, first, middle, and last name, and both suffixes.

Return

Return Type
nvarchar(700)

Parameters

Parameter	Parameter Type	Mode
@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_NAMEFORMATFUNCTION_SIMPLE(
                --NameFormatParamList

                @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
            as begin
                declare @result nvarchar(700);
                set @result = '';

                if len(@TITLE) > 0
                    set @result = @result + @TITLE;

                if len(@FIRSTNAME) > 0
                    set @result = @result + N' ' + @FIRSTNAME;

                if len(@MIDDLENAME) > 0
                    set @result = @result + N' ' + dbo.UFN_MAKEINITIALS(@MIDDLENAME);

                if len(@LASTNAME) > 0
                    set @result = @result + N' ' + @LASTNAME;

                if len(@SUFFIX) > 0
                    set @result = @result + @SUFFIX;

                return replace(ltrim(@result), N' ,', N',');
            end