the LIKE function

Hi ..

i'm using jsp with an MS Access 2003 database ..

i wanna use the like function inside a JSP query statement using the LIKE function, but i can't get any result whne i use the MS Access query syntax in the JSP ..

what i wanna know is how to write the following using JSP? :

query= "select * from TableName where col like "*n*";

this stement will return any record containing an " n " in its col if i used that in Access .. but how to write the above statement in JSP ..

i appreciate ur help :) ..

[557 byte] By [d2da] at [2007-10-3 1:37:54]