UFN_CONSTITUENT_ISNATIONALFUNDRAISINGGROUP

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

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

            return 0;
        end