Case insensitive searches

[Eric Forget]

Hi Chuck 
> I want to do searches that are case insensitive. What would you recommend?
> Do I need to write a method that converts fields to all upper case, index
> them, and do the search against them? Or, would you convert all fields to
> all upper case as they're stored in the database? I really don't like the
> second option because I want to display the records back to the users to
> select.

Just create a second method field with "LOWER(field1)". And then search on
that field. I've done it, it works fine.

Éric 

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>

 Fingerprint <86D5 38F5 E1FD 5D9C 71C3  BAA3 797E 70A4 6210 C684>