UFN_CONSTITUENT_ISFUNDRAISINGGROUP

create function dbo.UFN_CONSTITUENT_ISFUNDRAISINGGROUP(@CONSTITUENTID uniqueidentifier)
      returns bit
            with execute as caller
            as begin

            if exists(
                select
                    ID
                from
                    dbo.TEAMEXTENSION
                where
                    TEAMEXTENSION.TEAMCONSTITUENTID = @CONSTITUENTID
            ) return 1;

            return 0;
        end