@phelyan said:
Do you mean something like:
CREATE TABLE tmp SELECT DISTINCT * FROM Contact;
DELETE FROM Contact;
INSERT INTO Contact SELECT * FROM tmp;
DROP TABLE tmp;(Or '<FONT face="Courier New" size=2>SELECT DISTINCT * INTO tmp FROM Contact;</FONT>', depending on your flavour of SQL)
Sort of. But that's not a great practice because names could have been typo'd or shortened (e.g., Robert -> Rob). To catch some of this I'm using soundex.
What about comparisons of address data? Soundex doesn't work so well with street names.