UFN_FUNDINGPLAN_GETNAME

            create function dbo.UFN_FUNDINGPLAN_GETNAME
            (
                @ID uniqueidentifier
            ) 
            returns nvarchar(100) 
            with execute as caller
            as
            begin
                declare @NAME nvarchar(100)

                select 
                    @NAME = NAME 
                from 
                    dbo.FUNDINGPLAN 
                where 
                    ID = @ID

                return @NAME
            end