UFN_NAMEFORMATDEFAULT_GETNAMEFORMATDEFAULTS

            create function dbo.UFN_NAMEFORMATDEFAULT_GETNAMEFORMATDEFAULTS()
            returns table
            as
            return
            (
                select NFD.ID,
                       NFD.APPLYTOCODE,
                       NFD.NAMEFORMATTYPECODEID,
                       NFD.NAMEFORMATFUNCTIONID,
                       NFD.PRIMARYADDRESSEE,
                       NFD.PRIMARYSALUTATION  
                from dbo.NAMEFORMATDEFAULT as NFD
            );