>Hello All:
>
> I'm trying to write an application that takes a user-entered name and matches it with names in a table. If the name isn't found I wan't to try to do an inaccurate match and get a list of names that are 1 or 2 letters different. These are international names which easily have 7 separate words in a name. Does anyone have any ideas on how to do something like this? Thanks in advance.
>
> -Josh

Take a look at DIFFERENCE( ) and SOUNDEX( ) functions.

Check also Thread #498800 an Message #459963 .