UFN_NAMINGOPPORTUNITYFACILITY_GETNAME

                create function dbo.UFN_NAMINGOPPORTUNITYFACILITY_GETNAME
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(100) with execute as caller
                as
                    begin
                        declare @NAME nvarchar(100)
                        select
                            @NAME = NAME
                        from
                            dbo.NAMINGOPPORTUNITYFACILITY
                        where
                            ID = @ID

                        return @NAME
                    end