I know how to eliminate duplicate records from a database. But what happens when someone spells their name wrong? Is there a way to know that George Washington and George Washintgon are the same person?
not really...it would be like trying to find out if "a" and "s" are the same...you could build some search functons to compare the characters, but you may catch ones that are suppose to be different. One solution is dont make typos.
your code only does what you ask it to do. And if you want go to the extent of doing those name matchings in your code<BR>you have to set your own boundaries, as there can be no. of ways a name can be misspelled. i would say it's a waste job.