UFN_REVENUESPLIT_GETDESCRIPTION

                CREATE function dbo.UFN_REVENUESPLIT_GETDESCRIPTION
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(700)
                as
                begin
                    declare @DESCRIPTION nvarchar(700);
                    select top 1 @DESCRIPTION = '(' + REVENUESPLIT.APPLICATION + ') ' + cast(REVENUESPLIT.AMOUNT as nvarchar(20)) + ' ' + coalesce(REVENUEPAYMENTMETHOD.PAYMENTMETHOD, 'None') + ' - ' + ltrim(rtrim(CONSTITUENT.NAME))
                    from dbo.REVENUESPLIT 
                    inner join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
                    left join dbo.REVENUEPAYMENTMETHOD on REVENUEPAYMENTMETHOD.REVENUEID = REVENUE.ID
                    inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
                    where REVENUESPLIT.ID = @ID
                    order by REVENUESPLIT.AMOUNT desc;

                    return @DESCRIPTION;
                end