Are there any tools or methods that can be used for matching by a person's name between two different data sources? The systems have no other common information and the names have been entered differently in many cases. Examples of non-exact matches: King Jr., Martin Luther = King, Martin (exclude suffix) Erving, Dr. J. = Erving, J. ...
I am working on a requirement to match people from different databases. One tricky problem is variance in names like Bob - Robert, Jim - James, Lizzy - Elizabeth etc across databases. Is there a lookup/translation available for this kind of a requirement. ...
I'm trying to figure out the best approach to display combined tables based on matching logic and input search criteria. Here is the situation: We have a table of customers stored locally. The fields of interest are ssn, first name, last name and date of birth. We also have a web service which provides the same information. Some of ...