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' On 8/7/07, Lee Crain <[EMAIL PROTECTED]> wrote: > I am working on an application where I am importing data for which great > care has NOT been taken to ensure uppercase and lowercase letters have > been entered appropriately. > > > Would a search for an 'a' return a different result than a search for an > 'A'? > > > SELECT * FROM table WHERE field1 = 'a'; > > Vs. > > SELECT * FROM table WHERE field1 = 'A'; > > > If SQLite is case sensitive, is there an easy override for this to enforce > all lowercase letters? > > Thanks, > > Lee Crain > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ S&T Policy Fellow, National Academy of Sciences http://www.nas.edu/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
