UFN_CONSTITUENT_GETLOOKUPID

Find the LookupID 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_GETLOOKUPID(@CONSTITUENTID uniqueidentifier)
            returns nvarchar(100)
            as 
            begin
                declare @lookupID nvarchar(100);

                select @lookupID = LOOKUPID
                from dbo.CONSTITUENT
                where ID = @CONSTITUENTID;

                return @lookupID;
            end