upper(lastname) like upper(<dtml-sqlvar lastname type=string>)
* Don't use LIKE without any regular expression

* Use ILIKE instead of UPPER(...) = UPPER(...) since it's usually faster (I've "proven" this for PostgreSQL at least)

* Fastest method is always to use an index and you can write an index based on the UPPER() of a column. I've done this for a postcode table and sped up my queries by more than 10 times.


On 06/09/07, *Jaroslav Lukesh* < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    Use MS-SQL or Sybase :o)

    ----- Original Message -----
    From: "onsombal" <[EMAIL PROTECTED] <mailto:[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 <mailto: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
    <http://mail.zope.org/mailman/listinfo/zope-dev> )



------------------------------------------------------------------------

_______________________________________________
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 )

--
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com
_______________________________________________
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