On 3/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
If I want to do "SELECT * FROM table WHERE field = value", how can I do this matching text only and not case?
you can do it in your application using the language of your choice by upcasing or downcasing your field and value. Here is a Perl example SELECT * FROM table WHERE upper(field) = uc($value) or, you can define your column (done at CREATE TABLE time) with a COLLATE NOCASE option. See <http://www.sqlite.org/datatype3.html#collation> -- 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/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
