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.