UFN_PARTIALINFORMATIONSEARCH_BUILDNAMEFULL

Returns a full name when given a first name and key name

Return

Return Type
nvarchar(300)

Parameters

Parameter	Parameter Type	Mode
@PREFIX	nvarchar(50)	IN
@FIRSTNAME	nvarchar(50)	IN
@MIDDLENAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@SUFFIX	nvarchar(50)	IN

Definition

Copy



            create function dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDNAMEFULL(
                @PREFIX nvarchar(50),
                @FIRSTNAME nvarchar(50),
                @MIDDLENAME nvarchar(50),
                @KEYNAME nvarchar(100),
                @SUFFIX nvarchar(50)
            )
            returns nvarchar(300)
            with execute as caller
            as begin
                declare @NAME nvarchar(300) = @PREFIX +
                    case when len(@PREFIX) > 0 and len(@FIRSTNAME) > 0 then ' ' else '' end + @FIRSTNAME 
                set @NAME = @NAME + 
                    case when len(@NAME) > 0 and len(@MIDDLENAME) > 0 then ' ' else '' end + @MIDDLENAME
                set @NAME = @NAME + 
                    case when len(@NAME) > 0 and len(@KEYNAME) > 0 then ' ' else '' end + @KEYNAME
                set @NAME = @NAME + 
                    case when len(@NAME) > 0 and len(@SUFFIX) > 0 then ' ' else '' end + @SUFFIX

                return @NAME
            end