UFN_BBNC_GETCONSTITUENTNAME

Returns a formatted name for the specified CONSTITUENT ID for Blackbaud Internet Solutions.

Return

Return Type
nvarchar(154)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@MAPID	int	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETCONSTITUENTNAME(@CONSTITUENTID uniqueidentifier, @MAPID int) 
            returns nvarchar(154)
            as begin
                if @CONSTITUENTID is null and coalesce(@MAPID,0) > 0
                    select 
                        @CONSTITUENTID = ID 
                    from
                        dbo.CONSTITUENT
                    where
                        CONSTITUENT.SEQUENCEID = @MAPID;

                return (
                    select dbo.UFN_CONSTITUENT_BUILDNAME(@CONSTITUENTID)
                    )
            end