finding similar records

[shanedavid1981]

Hi,

I have a problem thats been building up for quite some time now...

I have just been given a huge QA database to oversee and manage, but the auditees have had their usernames manually entered all this time... you know whats coming...

I now have 100,000 + records where the usernames entered do NOT match my master list from the servers... but this also includes people who have left the company.

Is there any way I can make a query to pick out similarities between the mater list and the table?

Any insights into this would be brilliant....thanks!

 

[PHV]

Take a look at SOUNDEX

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244