[Zope-dev] ZSQL Question

Hello, is there a way in Zope to search on the pattern of the field in the database?? for example:: through ZODBC using ZSQL connected to ACCESS database I have a query that goes like this: select * from SomeTable where (SomeField Like '*project*') If I run this SQL in ACCESS directly it returns all the records where the field SomeField has the word "project" anywhere in the text... but when I run it through the ZSQL I get nothing in return..... Is there another key word to be used with ZSQL or is it just imposible to query on the patterns???? What's weird, the ZSQL does not choke on the "Like" word... it just says that there was no data matching the query... any one has any ideas?