UFN_SEARCH_APPLICATIONCOMMITMENT_DESCRIPTION

                create function dbo.UFN_SEARCH_APPLICATIONCOMMITMENT_DESCRIPTION
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(500)
                as
                begin

                    declare @DESCRIPTION as nvarchar(500);

                    --First check if it is revenue

                    select 
                        @DESCRIPTION = REVENUE.DESCRIPTION
                    from dbo.REVENUE
                    where
                        REVENUE.ID = @ID

                    --Check memberships

                    if @DESCRIPTION is null
                        select 
                            @DESCRIPTION = dbo.UFN_MEMBERSHIP_GETDESCRIPTION(MEMBERSHIP.ID)
                        from dbo.MEMBERSHIP
                        where
                            MEMBERSHIP.ID = @ID

                    --Check event registrants

                    if @DESCRIPTION is null
                        select 
                            @DESCRIPTION = dbo.UFN_REGISTRANT_GETDESCRIPTION(REGISTRANT.ID)
                        from dbo.REGISTRANT
                        where
                            REGISTRANT.ID = @ID

                    return isnull(@DESCRIPTION,'');
                end