...

Oh and try % not *. Thanks. It works. Correct quoting was also necessary, but real problem was

Make note to use <dtml-var name="sql_delimiter"> instead of ending your queries with a ; Troy -----Original Message----- From: Thomas B. Passin [mailto:tpassin@mitretek.org] Sent: Wednesday, April 18, 2001 12:33 PM To: zope@zope.org Subject: Re: [Zope] "Like" in Z SQL methods (Z ODBC+MS Access) Mariusz Błoński wrote - *

instead of %.

Yes, the "%" is standard SQL syntax. Tom P _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )