Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fuzzy compare of columns

607185Jun 4 2008 — edited Jun 4 2008
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2008
Added on Jun 4 2008
16 comments
1,758 views