Find the dups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to find the dups in one of my table, there are all the company names
in the records, I know how to use the dups query, but my record have some
names like 'psc inc.' and 'psc,inc.' , how can I run the dups query exclude
the punctuation.
 
Hi find the dups,

Try the replace function to remove punctuation, then check on those. Nest
them to remove multiple items... or write yourself a function to strip out
all whitespace and non alpha chars and compare on that.

Here's a sample of using the replace function:

replace(replace("bob, inc.", ",", ""), ".", "") will return "bob inc"

Try it!!

Damian.
 
You may want to look at the SoundEX function. The function is not clean, but
it does ignore punctuation and other "noise characters".
 
Back
Top