UFN_PHONE_PRIMARYCOUNT

Returns the number of primary phone numbers for a constituent.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PHONE_PRIMARYCOUNT(@CONSTITUENTID uniqueidentifier)
            returns int
            as begin
                return (select count(*) from dbo.PHONE where (CONSTITUENTID = @CONSTITUENTID) and (ISPRIMARY = 1))
            end