UFN_EVENT_CONSTITUENTISREGISTRANT

            create function dbo.UFN_EVENT_CONSTITUENTISREGISTRANT(@EVENTID uniqueidentifier, @CONSTITUENTID uniqueidentifier)
            returns bit
            with execute as caller
            as
            begin
                if exists(select ID from dbo.REGISTRANT where CONSTITUENTID = @CONSTITUENTID and REGISTRANT.EVENTID = @EVENTID) begin
                    return 1;
                end;

                return 0;
            end