Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL statement for approximate string matching
Well Marc, the SOUNDEX function (or DIFFERENCE function, which is based on SOUNDEX) works quite well in some cases. One specific case where it doesn't work well is when the two strings that are compared are similar, but they don't start with the same letters; for instance "Apple Co" and "The... -
SQL statement for approximate string matching
I believe the form of an expression in a WHERE clause is a bit more general, such as WHERE #expression1# #operator# #expression2# But man, I just figured out what I did wrong in that SQL-query, and indeed, it was just a simple syntax error. The syntax of the CASE construct is of the form "CASE... -
SQL statement for approximate string matching
Hello, I'm trying to compose an SQL-query which does approximate string matching using n-grams. This is the problem that I'm trying to solve: we have a system on which you can register your company and users within that company. However, before a new company is registered, we would like to do a...
