Use of either "OR" or "Lower/Upper" will bypass any index and force a full table scan. Much better to use COLLATE NOCASE instead or a custom collation if you need internationalized comparisons.
Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Tuesday, August 07, 2007 6:15 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is SQLite Case Sensitive? SQL is not case-sensitive, but SQL comparisons are. Use the following SELECT * FROM table WHERE field1 = 'a' OR field1 = 'A' you can also use WHERE Lower(field1) = 'a' or WHERE Upper(field1) = 'A' ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
