Re: sql query using LIKE

[Oystein Grovlen]

Nik wrote:

I'm getting an SQL excpetion using LIKE to match a String.

String query = "SELECT *" + " FROM "+ tableName +

                       "WHERE DAY_OF_WEEK LIKE \""+
                       searchTerms+"\"";
is there some other way I should be doing this?

You need to use single quotes for the search term, not double quotes.

--
Øystein