UFN_MEMBERSHIP_HASOUTSTANDINGPLEDGE

            create function dbo.UFN_MEMBERSHIP_HASOUTSTANDINGPLEDGE
            (
                @MEMBERSHIPID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @PLEDGEID uniqueidentifier;

                set @PLEDGEID = dbo.UFN_MEMBERSHIP_GETPLEDGE(@MEMBERSHIPID)

                if @PLEDGEID is not null
                begin
                    if dbo.UFN_PLEDGE_GETBALANCE(@PLEDGEID) > 0
                        return 1
                end

                return 0
            end