Posted by theintrepidfox on 07/23/07 13:15

Dear Group

Please accept my apologies for this trivial question. I can't get it
to work.
What I'm trying to achieve is to find duplicate contact records. E.g.
There might be two records relating to the same individual. Being
enetered as Phil Baker and Philip Baker. For that purpose I do a
duplicate serach on the lastname and a comparison on the first two
characters of the firstname to get a list of potential duplicates.

Please fiond the script I tried below.

SELECT ContactID, Lastname, Firstname FROM Contacts
WHERE LEFT(Firstname,2) IN
(SELECT LEFT(Firstname,2) FROM Contacts GROUP BY HAVING COUNT(*)>1)
AND Lastname IN
(SELECT Lastname FROM Contacts List GROUP BY Lastname HAVING
COUNT(*)>1)
ORDER BY Lastname ASC

I'm grateful for any hints and suggestions.
Thank you very much for your time and efforts,

Martin

• Next in forum: Update Guid column on any update to table row
• Prev in forum: Re: Problem with nested function call (UDFs)
• Thread view: Need help with finding duplicate records please

[Reply to this message]