UFN_CONSTITUENT_DISPLAYNAME

Provides access to the formatted constituent display name

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENT_DISPLAYNAME
(
    @ID uniqueidentifier
)
returns table
as
return (
    select
        CASE ISORGANIZATION WHEN 1 THEN
            CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' +  KEYNAME END
        ELSE
            CASE ISGROUP WHEN 1 THEN
                CASE DISPLAYNAME WHEN '' THEN KEYNAME ELSE DISPLAYNAME END
            ELSE
                CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END
                +
                CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END
                + 
                KEYNAME
            END
        END as NAME
    from dbo.CONSTITUENT with(nolock)
    where dbo.CONSTITUENT.ID = @ID
)