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 -~----------~----~----~----~------~----~------~--~---
