On Jul 25, 2008, at 7:44 PM, Harold Wood & Meyuni Gani wrote: > But you can use where 'AA' = upper(fld1) = to get around case issues.
Yes you can. But you need to be aware that doing so will prevent an index from being used to speed the search. If your table is small it shouldn't make any difference. But for a table with millions of entries, you could run into performance problems. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
