UFN_PARTIALINFORMATIONSEARCH_BUILDNAME

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

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@FIRSTNAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN

Definition

Copy



            CREATE function dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDNAME(
                @FIRSTNAME nvarchar(50),
                @KEYNAME nvarchar(100)
            )
            returns nvarchar(200)
            with execute as caller
            as begin
                declare @NAME nvarchar(300) =
                    @FIRSTNAME + 
                    case when len(@KEYNAME) > 0 and len(@FIRSTNAME) > 0 then ' ' else '' end +
                    @KEYNAME;

                return @NAME
            end