>Has anyone used these commands before? Do they work? According to the Hackers Guide it is a waste of time. I have tried both with varying results. I have 2 records one "Joe Smith" and the other with "Joseph Smith" if they have the sam name and addres then I need to delete one. Both soundex and difference pick it up sometimes and sometimes they dont.
>
>Any advice?

Anthony,

I have the same experience with soundex and agree with the Hackers Guide. My routines for finding duplicates compare all fields......if addresses match, the first is kept, the next deleted.

Greg