UFN_INVITEE_GETNAME

            CREATE function dbo.UFN_INVITEE_GETNAME(@ID uniqueidentifier)
            returns nvarchar(700)
            as
            begin
                declare @NAME nvarchar(700)

                select 
                    @NAME = NF.NAME 
                from 
                    dbo.INVITEE
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(INVITEE.CONSTITUENTID) NF
                where 
                    ID = @ID

                return @NAME
            end