[Zope-DB] Making case-insensitive in sqlgroup

Joshua Burvill josh at mri.com.au
Mon Nov 1 16:26:32 EST 2004

Hello to everyone,

I am using zope 2.6.4, firebird 1.0, and kinterbasdbda and I would like to
make the following query case-insensitive.

<dtml-sqlgroup where>
<dtml-sqltest location op=eq type=nb optional>

If I was not using the convenient sqlgroup syntax, I would probably use
something like:

where upper(location) = upper( <dtml-sqlvar location type=string> )

Does anyone know how to do this?

Regards, Josh

More information about the Zope-DB mailing list