Use MS-SQL or Sybase :o)
----- Original Message -----
From: "onsombal" <[EMAIL PROTECTED]>
is there an easy way to make the following ZSQL query case-insensitive?
select * from clients
<dtml-sqlgroup where>
<dtml-sqltest firstname op="like" type="string" optional>
<dtml-or>
<dtml-sqltest lastname op="like" type="string" optional>
<dtml-or>
<dtml-sqltest client op="like" type="string" optional>
</dtml-sqlgroup>
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )