UFN_PHILANTHROPICGIFTCATEGORY_GETNAME

create function dbo.UFN_PHILANTHROPICGIFTCATEGORY_GETNAME(@ID uniqueidentifier) 
            returns nvarchar(201) 
            with execute as caller
            as begin
                declare @CATEGORYNAME nvarchar(201);

                select 
                    @CATEGORYNAME = DESCRIPTION
                from 
                    dbo.PHILANTHROPICGIFTCATEGORY
                where 
                    ID = @ID;

                return @CATEGORYNAME;

            end