UFN_CONSTITUENT_ISCOMMITTEEMEMBER

        CREATE function dbo.UFN_CONSTITUENT_ISCOMMITTEEMEMBER(@CONSTITUENTID uniqueidentifier)
        returns bit
        with execute as caller
        as begin        
            if exists(
                    select top 1 ID
                    from 
                      dbo.GROUPMEMBER GM
                    where 
                      GM.MEMBERID = @CONSTITUENTID
                    and dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GM.ID) = 1
                    and dbo.UFN_CONSTITUENT_ISCOMMITTEE(GM.GROUPID) = 1
            ) return 1;

            return 0;
        end