UFN_NAMEFORMAT_01

Default name format.

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_NAMEFORMAT_01](
                @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 + N' '

                if len(@SPOUSETITLE) > 0 and (len(@result) > 0)
                    set @result = @result + N'and '

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

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

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

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

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

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