UFN_CONSTITUENT_GETMAIDENNAME_TVF

Find the Maiden Name for a given constituent

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@CONSTITUENTID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_CONSTITUENT_GETMAIDENNAME_TVF(@CONSTITUENTID uniqueidentifier)
returns table
as
return
(
    select MAIDENNAME as VALUE
    from dbo.CONSTITUENT with(nolock)
    where ID = @CONSTITUENTID
)