UFN_FUZZYCONSTITUENTCOMPARER_COMPARECONSTITUENTS_2

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FIRSTNAME1	nvarchar(100)	IN
@FIRSTNAME2	nvarchar(100)	IN
@FIRSTNAMESHOULDEXACTMATCH	bit	IN
@MIDDLENAME1	nvarchar(100)	IN
@MIDDLENAME2	nvarchar(100)	IN
@MIDDLENAMESHOULDEXACTMATCH	bit	IN
@KEYNAME1	nvarchar(100)	IN
@KEYNAME2	nvarchar(100)	IN
@KEYNAMESHOULDEXACTMATCH	bit	IN
@MAIDENNAME1	nvarchar(100)	IN
@MAIDENNAME2	nvarchar(100)	IN
@MAIDENNAMESHOULDEXACTMATCH	bit	IN
@GENDER1	nvarchar(5)	IN
@GENDER2	nvarchar(5)	IN
@GENDERSHOULDEXACTMATCH	bit	IN
@ADDRESS1	nvarchar(300)	IN
@ADDRESS2	nvarchar(300)	IN
@ADDRESSSHOULDEXACTMATCH	bit	IN
@CITY1	nvarchar(100)	IN
@CITY2	nvarchar(100)	IN
@CITYSHOULDEXACTMATCH	bit	IN
@STATE1	nvarchar(100)	IN
@STATE2	nvarchar(100)	IN
@STATESHOULDEXACTMATCH	bit	IN
@COUNTRY1	nvarchar(100)	IN
@COUNTRY2	nvarchar(100)	IN
@COUNTRYSHOULDEXACTMATCH	bit	IN
@PHONE1	nvarchar(100)	IN
@PHONE2	nvarchar(100)	IN
@PHONESHOULDEXACTMATCH	bit	IN
@EMAIL1	nvarchar(100)	IN
@EMAIL2	nvarchar(100)	IN
@EMAILSHOULDEXACTMATCH	bit	IN
@EMPLOYER1	nvarchar(300)	IN
@EMPLOYER2	nvarchar(300)	IN
@EMPLOYERSHOULDEXACTMATCH	bit	IN

Definition

Function Definition
This function has an external implementation defined by