UFN_REGISTRANT_GETNAMEDIRECTORYSTYLE

create function dbo.UFN_REGISTRANT_GETNAMEDIRECTORYSTYLE
(
    @ID uniqueidentifier
)
returns nvarchar(700)
with execute as caller
as begin
    return (
        select
            case when REGISTRANT.CONSTITUENTID is null
                then 'Guest of ' + NF.NAME
                else dbo.UFN_NAMEFORMAT_08(CONSTITUENT.ID, CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, CONSTITUENT.MIDDLENAME, null, null, null, null, null, null, null)
                end
        from 
            dbo.REGISTRANT
            left join dbo.REGISTRANT as GUESTOF on GUESTOF.ID = REGISTRANT.GUESTOFREGISTRANTID
            left join dbo.CONSTITUENT on CONSTITUENT.ID = REGISTRANT.CONSTITUENTID
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(coalesce(REGISTRANT.CONSTITUENTID, GUESTOF.CONSTITUENTID)) NF
        where 
            REGISTRANT.ID = @ID
    );
end