UFN_CONSTITUENT_ISFUNDRAISER

        create function dbo.UFN_CONSTITUENT_ISFUNDRAISER(@CONSTITUENTID uniqueidentifier)
        returns bit
        with execute as caller
        as begin
            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

            declare @UPPERBOUND datetime;
            set @UPPERBOUND = dbo.UFN_DATE_GETLATESTTIME(@CURRENTDATE);

            declare @LOWERBOUND datetime;
            set @LOWERBOUND = dbo.UFN_DATE_GETEARLIESTTIME(@CURRENTDATE);

            if exists(
                select
                    ID
                from
                    dbo.FUNDRAISERDATERANGE
                where
                    FUNDRAISERDATERANGE.CONSTITUENTID = @CONSTITUENTID and
                    (FUNDRAISERDATERANGE.DATEFROM <= @UPPERBOUND or FUNDRAISERDATERANGE.DATEFROM is null) and
                    (FUNDRAISERDATERANGE.DATETO >= @LOWERBOUND or FUNDRAISERDATERANGE.DATETO is null)
            ) return 1;

            return 0;
        end