WildCard question on ASP and access

I stuck in the problem of using wildcard with ASP and Access.
I used the statment in ASP page. It doesn't return any record for me. I printed out the same statement and pasted in Access. It returns me the right recordset.

In the statement, I used "select * from table1 where table1.field1 like '*" & Request("whatever") & "*'"

Could anyone know why?

I appreciate you answer.

Who is Participating?
PBallConnect With a Mentor Commented:
replace the wildcard with %

"SELECT * FROM Table1 WHERE Table1.Field1 LIKE '%" & .... & "%"

* only works from within Access.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.