I am using a VB6 Enterprise Edition, and I am accesing an MS Access database using MS Jet 4.0...

How can I use the LIKE query? If I can't, how can I search a database for a substring instead of the whole data in the record?