problem in connecting ASP pages with access

I'm using ASP which connected to microsoft access DB. when I wrote SQL statement for search by key word, it doesn't work.
is it because access do not accept (like%.....% ) statement???
plz I need answer as soon as possible.

Thanks

Try to check this out might help...


The LIKE Condition
The LIKE condition is used to specify a search for a pattern in a column.

Syntax
SELECT column FROM table
WHERE column LIKE pattern


A "%" sign can be used to define wildcards (missing letters in the pattern) both before and after the pattern.


Using LIKE
The following SQL statement will return persons with first names that start with an 'O':

SELECT * FROM Persons
WHERE FirstName LIKE 'O%'


The following SQL statement will return persons with first names that end with an 'a':

SELECT * FROM Persons
WHERE FirstName LIKE '%a'


The following SQL statement will return persons with first names that contains the pattern 'la':

SELECT * FROM Persons
WHERE FirstName LIKE '%la%'


HTH...

HAppy programming...