Searching For Matching Records|Conversion And Matching Functions And Aliases
Conversion And Matching Functions And Aliases
FindDuplicateRecords uses special data conversion and matching functions to identify matching records.
Conversion functions change data in one form to another - for example the function CONVERT_TO_UPPER_CASE() internally converts data to uppercase before matching takes place.
A number of conversion functions are supplied, but you can create your own if you wish. Just set up an alias for one or more conversion functions in the 'Match Aliases' screen.
Aliases are shortened, convenient forms representing one or more other conversion aliases combined.
Matching functions tell FindDuplicateRecords how to match data. For example the matching function =() means that to match both values must be identical, whereas
The matching function SOUNDEX_MATCH() means that to match, both data values must generate the same Soundex code (this means that when spoken aloud, they must sound quite similar).
Matching functions can be aliased too. To create your own matching function, use the 'Matching Aliases' screen.