Providing your database has the upper() function, or replace with similar


select ...
<dtml-sqlgroup where>
  <dtml-if firstname>
     upper(firstname) like upper(<dtml-sqlvar firstname type=string>)
   </dtml-if>
  <dtml-or>
    <dtml-if lastname>
     upper(lastname) like upper(<dtml-sqlvar lastname type=string>)
   </dtml-if>
  <dtml-or>
    ...etc...
  </dtml-sqlgroup>

On 06/09/07, Jaroslav Lukesh < lukesh@seznam.cz> wrote:
Use MS-SQL or Sybase :o)

----- Original Message -----
From: "onsombal" <onsombal@yahoo.com>
>
> 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 )