UFN_CONSTITUENT_NAMEFORMATFUNCTIONS

create function dbo.UFN_CONSTITUENT_NAMEFORMATFUNCTIONS
(
    @CONSTITUENTID uniqueidentifier 
)
returns table
as
return
    select
        NF.ID,
        case when NF.DISPLAY is not null and len(NF.DISPLAY) > 0
            then NF.DISPLAY
            else replace(dbo.UFN_NAMEFORMATFUNCTIONSPEC(NF.ID), N'{CONDBREAK}', ' ')
        end as DISPLAY,
        dbo.UFN_NAMEFORMAT_FROMID(NF.ID, @CONSTITUENTID) EXAMPLE,
        /* SEQUENCE is not unique, so provide a 2nd order clause for consistency. */
        ROW_NUMBER() over (order by NF.SEQUENCE, DISPLAY) ROW
    from
        dbo.NAMEFORMATFUNCTION NF