SQL statement in ASP returns no records 1

[MandoThrasher]

SELECT * FROM tTable WHERE fField LIKE '*test*'

When I run this query natively in Access, I get records back.

When I pass this through ADO in ASP, I get nothing.

I think it has to do with the LIKE clause. Any ideas?

 

[BarkingFrog]

Try putting "%" where you have "*"

 

[MandoThrasher]

Hey, that worked!! Thanks a million!