[Zope-DB] Making case-insensitive in sqlgroup

[Joshua Burvill]

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>
<dtml-and>
...
</dtml-sqlgroup>


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