S
stelios
Dear all
I have a table with field1:surname and field2:name.
I need to perform a find duplicate query.
My problem is that field2 contains names, writen in a non standard
way, for example:
record1: surname: Smith, name:Andreas
record2: surname: Smith, name:Andr.
Is there a way to compare and find duplicates for field1 and for
field2 but only the first three characters of the name?
I need urgently help.
I would appreciete any suggestion.
Thanks in advance
Stelios
I have a table with field1:surname and field2:name.
I need to perform a find duplicate query.
My problem is that field2 contains names, writen in a non standard
way, for example:
record1: surname: Smith, name:Andreas
record2: surname: Smith, name:Andr.
Is there a way to compare and find duplicates for field1 and for
field2 but only the first three characters of the name?
I need urgently help.
I would appreciete any suggestion.
Thanks in advance
Stelios