sql query using LIKE

[Nik]

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?
Nik