UFN_SELECTION_CONSTITUENT_MARKADAMSON

Returns all CONSTITUENT IDs for constituents named 'Mark Daniel Adamson'.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_SELECTION_CONSTITUENT_MARKADAMSON
            (
            )
            returns table 
            as return
            select
                ID
            from dbo.CONSTITUENT
            where KEYNAME = 'Adamson' and FIRSTNAME = 'Mark' and MIDDLENAME = 'Daniel';