USP_DATALIST_CONSTITUENTFORMATTEDNAME

Returns a list that contains the formatted name for a constituent using the given name format function.

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATFUNCTIONID	uniqueidentifier	IN	Name format function

Definition

Copy



        CREATE procedure dbo.USP_DATALIST_CONSTITUENTFORMATTEDNAME
        (
          @NAMEFORMATFUNCTIONID uniqueidentifier
        )
        as
            set nocount on;

            select replace(dbo.UFN_NAMEFORMATFUNCTIONSPEC(@NAMEFORMATFUNCTIONID), N'{CONDBREAK}', ' ') as FORMATTEDNAME