UFN_CONSTITUENT_GETTITLE2

Retrieve Title 2 for a given constituent

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CONSTITUENT_GETTITLE2(@CONSTITUENTID uniqueidentifier)
returns nvarchar(100)
as 
begin
    declare @TITLE2 nvarchar(100) = N'';

    select 
        @TITLE2 = TITLECODE.DESCRIPTION
    from dbo.CONSTITUENT
    inner join dbo.TITLECODE
        on CONSTITUENT.TITLE2CODEID = TITLECODE.ID
    where CONSTITUENT.ID = @CONSTITUENTID;

    return @TITLE2;
end