UFN_NAMEFORMATFUNCTIONEXAMPLE

            create function dbo.UFN_NAMEFORMATFUNCTIONEXAMPLE(@NAMEFORMATFUNCTIONID uniqueidentifier)
            returns nvarchar(700)
            with execute as owner
            as begin

                declare @xml xml;  

                select @xml = (  
                    select NAMEFORMATFIELD.EXAMPLE [fieldValue], 
                           NAMEFORMATFUNCTIONDETAIL.REMOVETRAILINGSPACE [removeTrailingSpace],
                           NAMEFORMATFUNCTIONDETAIL.INITIAL [useInitial],
                           NAMEFORMATFUNCTIONDETAIL.SMARTREMOVE [smartRemove]
                    from NAMEFORMATFUNCTIONDETAIL
                    inner join NAMEFORMATFIELD
                        on NAMEFORMATFUNCTIONDETAIL.NAMEFORMATFIELDID = NAMEFORMATFIELD.ID
                    where NAMEFORMATFUNCTIONDETAIL.NAMEFORMATFUNCTIONID = @NAMEFORMATFUNCTIONID
                    order by NAMEFORMATFUNCTIONDETAIL.SEQUENCE
                for xml raw('Field'), type, BINARY BASE64);

                declare @name nvarchar(700) = dbo.UFN_GETFORMATTEDNAME(@xml);

                return @name;

            end