I have a straightforward name & address table,
each record has a unique ID (primary key)

I need to identify the ID of those records
that are duplicated across the name and address
fields, possibly with some degree of mismatch (ie
a %LIKE% element)

Cannot figure out the SQL at all as COUNT
just tells me I have duplicates, not which
they actually are

Regards


Roger Pullen