can't use = and don't want to use LIKE in WHERE

abbylee26 · August 22nd, 2003, 02:58 PM

sSQL = "SELECT * " & _
" FROM MasterTableCfoapal2" & _
" WHERE ACCOUNT LIKE '%" & Request.Form("search_string") & "%'" & _
" or SUB LIKE '%" & Request.Form("search_string") & "%'" & _
" or Division LIKE '%" & Request.Form("search_string") & "%'" & _
" or DIRECTOR = '%" & Request.Form("search_string") & "%'" & _
" ORDER BY ACCOUNT, SUB"
set rs = Connect.Execute(sSQL)

For some reason when I look for a "DIRECTOR" I always get no replies. Do I need to do something like chomp the string before checking it? How? I can use "LIKE" instead of "=" but then I get some items from other parts of the search that I don't want.

planoie · August 22nd, 2003, 03:42 PM

If you want to look for a specific "DIRECTOR" you should use = and ommit the % in the search string. If you want to use % you have to use LIKE. The reason you get no rows returned is that when you use = the search is looking for the literal character "%" in the values, not using is as a wildcard the way LIKE uses it.