Re: [Zope] "Like" in Z SQL methods (Z ODBC+MS Access)

Mariusz Błoński asked

Why SELECT * from query where field like "100*"; doesn't work in Z SQL Method? It works in Access.

Correct SQL syntax uses single quotes around strings, such as select * from query where field like '100*' Access may silently convert to the correct form, but the Zope driver may not. Or, depending on how you construct the string, tehre may be a problem with the quotation marks. They may need to be escaped. Cheers, Tom P