Fuzzy compare of columns
607185Jun 4 2008 — edited Jun 4 2008Hi, I searched the forum, but could not find anything relevant. I am trying to compare two tables that have similar column names. This issue is with the data. I have matched up on numerous fields, but a lot of records fall out due to naming convention differences.
example
Table 1
Business_Name
Address
City
State
Table 2
Business_Name
Address
City
State
I am trying to find a way to do a fuzzy compare of data since whoever entered the data was inconsistent with naming companies.
Table 1 may have ABC Corp for a company name while table 2 has The ABC Corp.
Table 1 may have The BAC Corp, while table 2 has BAC Corp.
This is a simple example. Any suggestions?
Thanks
Kevin