UFN_NAMEFORMAT_FROMID

This function returns the built name based on the constituent id and name format function id.

Return

Return Type
nvarchar(700)

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATFUNCTIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_NAMEFORMAT_FROMID
            (
                @NAMEFORMATFUNCTIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            ) 
            returns nvarchar(700)
            with execute as caller
            as begin
                declare @NAME nvarchar(700);                
                select @NAME = dbo.UFN_NAMEFORMAT_FROMID_INTERNAL(@NAMEFORMATFUNCTIONID, @CONSTITUENTID, 0);                
                return @NAME;
            end;