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 )

Reply via email to