UFN_PLANNEDGIFT_GETDESCRIPTION

                create function dbo.UFN_PLANNEDGIFT_GETDESCRIPTION
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(500) 
                with execute as caller
                as
                begin
                    declare @DESCRIPTION nvarchar(500);

                    select
                        @DESCRIPTION = C.NAME
                    from
                        dbo.PLANNEDGIFT PG
                    left outer join
                        dbo.CONSTITUENT C on PG.CONSTITUENTID = C.ID
                    where
                        PG.ID = @ID;

                    return @DESCRIPTION;
                end