UFN_SELECTION_CONSTITUENT_REGISTRANTS

Gets all constituents who are event registrants.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_SELECTION_CONSTITUENT_REGISTRANTS()
            returns table
            as return
                select distinct
                    REGISTRANT.[CONSTITUENTID] as [ID]
                from
                    dbo.REGISTRANT
                where REGISTRANT.[CONSTITUENTID] is not null;