>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 .
--sb--