Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: StaciLangford
- Order by date
-
Query to remove 'almost' duplicates?
The data is pretty much just contact info - name, title, company, address, city, state, zip, phone, etc. An example I was talking about before could be: Melissa Smith 123 Main St. Columbus, OH 12345 Meilsa Smith 123 Main St. Columbus, OH 12345 I can't weed them out by address because I may...- StaciLangford
- Post #6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Query to remove 'almost' duplicates?
Hi. I am creating a report from a really messy database. There has been a lot of entry error resulting in duplicate records. I have been able to remove the exact duplicate records, but now I'm not sure how to get rid of the records that are off by a character or two due to mistyping (example...- StaciLangford
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 4 Other topics
