UFN_NAMEFORMATFUNCTION_FULLYQUALIFIED

This function returns the fully qualified name using the given parts.

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_FULLYQUALIFIED(
                --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(@SPOUSETITLE) > 0
                begin
                    if len(@TITLE) > 0
                        set @result = @result + N' and '
                    set @result = @result + @SPOUSETITLE
                end

                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

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