[Zope-dev] ZSQL Question

[Daniel Sashko]

    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?