I need to select the best match for a name in a database as a default value. Something like the SQL select code "WHERE name LIKE 'smith'", only if it fails, it needs to get the next best match, "smithe" or "smithers" or whatever. Using a SQL statement (or a data view) won't do it though, because I need to display the entire contents of the database I'm matching to. (The user is trying to find out if the name's already in there, misspelled or otherwise manged, and select it if it exists, so the program can drop in the appropriate primary key.)

All help appreciated.