Providing your database has the upper() function, or replace with similar <br><br><br>select ...<br><dtml-sqlgroup where><br> <dtml-if firstname><br> upper(firstname) like upper(<dtml-sqlvar firstname type=string>)
<br> </dtml-if><br> <dtml-or><br> <dtml-if lastname><br>
upper(lastname) like upper(<dtml-sqlvar lastname type=string>)<br>
</dtml-if><br> <dtml-or><br> ...etc...<br> </dtml-sqlgroup><br><br><div><span class="gmail_quote">On 06/09/07, <b class="gmail_sendername">Jaroslav Lukesh</b> <<a href="mailto:lukesh@seznam.cz">
lukesh@seznam.cz</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Use MS-SQL or Sybase :o)<br><br>----- Original Message -----
<br>From: "onsombal" <<a href="mailto:onsombal@yahoo.com">onsombal@yahoo.com</a>><br>><br>> is there an easy way to make the following ZSQL query case-insensitive?<br>><br>> select * from clients
<br>> <dtml-sqlgroup where><br>> <dtml-sqltest firstname op="like" type="string" optional><br>> <dtml-or><br>> <dtml-sqltest lastname op="like" type="string" optional>
<br>> <dtml-or><br>> <dtml-sqltest client op="like" type="string" optional><br>> </dtml-sqlgroup><br>><br>_______________________________________________<br>Zope maillist -
<a href="mailto:Zope@zope.org">Zope@zope.org</a><br><a href="http://mail.zope.org/mailman/listinfo/zope">http://mail.zope.org/mailman/listinfo/zope</a><br>** No cross posts or HTML encoding! **<br>(Related lists -<br>
<a href="http://mail.zope.org/mailman/listinfo/zope-announce">http://mail.zope.org/mailman/listinfo/zope-announce</a><br> <a href="http://mail.zope.org/mailman/listinfo/zope-dev">http://mail.zope.org/mailman/listinfo/zope-dev
</a> )<br></blockquote></div><br>