UFN_MATCHINGGIFTREVENUERELATION_GETDESCRIPTION

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

                select 
                    @DESCRIPTION =  ltrim(rtrim(CONSTITUENT.NAME))
                from dbo.REVENUESPLIT
                inner join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
                where REVENUESPLIT.ID = @ID;

                return @DESCRIPTION;
            end