UFN_CONSTITUENT_GETNICKNAME

Find the Nickname for a given constituent

Return

Return Type
nvarchar(50)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_GETNICKNAME(@CONSTITUENTID uniqueidentifier)
            returns nvarchar(50)
            as 
            begin
                declare @NICKNAME nvarchar(50);

                select @NICKNAME = NICKNAME
                from dbo.CONSTITUENT
                where ID = @CONSTITUENTID;

                return @NICKNAME;
            end