UFN_NAMEFORMAT_ISVALIDFORCONSTITUENT

Returns true iff a given name format is valid for a given constituent.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_NAMEFORMAT_ISVALIDFORCONSTITUENT
            (
                @NAMEFORMATID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns bit
            as
            begin
                declare @R bit;
                select @R = 
                    case when @CONSTITUENTID = (select CONSTITUENTID from dbo.NAMEFORMAT where ID = @NAMEFORMATID) then 1 
                    else 0 end;
                return @R;
            end