How do I write a SQL query that will find misspellings of names or similar names?
Posted on 2008-06-11
I have a SQL database with two tables. One table called tblConflict has a field called conflict number, Plaintiff and Defendant. The second table called tblConflict attorney has the link field conflict number and the name of the attorney. I have all of it linked together with a view. I want to be able to search for a name in the 3 columns ie Dorfman. It might be in the database as Dorfman, Dorphman, Dorman, or Dorphmen depending how the user entered originally. I need when you enter Dorfman that all four entries come up.