What you are actually trying to do is scrubbing/normalizing addresses. There is a large amount of research done and lots of good ways to do it but none of them are as simple as using LIKE.
There are some things that can be helpful using Oracle Text but if you are not familiar with it already I would highly recommend you purchase something that will do it for you even if you have to export the data and pull it back in. This is definitely one of those don't reinvent the wheel moments IMHO. On Mar 13, 11:21 pm, Rick <[email protected]> wrote: > Hi, > I have table Customer and I want to be able to find any duplicates or > anything that looks like duplicates from the Address_1 column and from > the same table. I would want to be able to identify similar addresses. > For example; > > 1909 Delaware Ave. > 1909 Delaware St. > > or > > 832 Magnolia St. #12 > 832 Magnolia St. #10 > > Using SQL, Can I come up with some Like statement with wildcard > characters? If so, how? > > Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
