ACC97: ASP Query Cannot Be Used with the LIKE Predicate

These are the things about DOS and Windows that frustrate me to no end. Who knew you can’t use asterisk but had to replace it with percentages when using ODBC?

Use Notepad or another text editor to open the FindName.ASP file. You need to change the SQL Statement so that it will use the appropriate sequence of parameter and wildcard characters. Change the SQL Statement so that it looks as follows:

sql = “SELECT Customers.CompanyName From Customers WHERE1

via ACC97: ASP Query Cannot Be Used with the LIKE Predicate.

  1. (Customers.CompanyName) Like ‘” & Request.QueryString(“[EnterName]”) & “%’ []