On Mon, 2 Sep 2013 02:12:05 +0100 Simon Slavin <slav...@bigfraud.org> wrote:
> > On 2 Sep 2013, at 2:03am, Joseph L. Casale <jcas...@activenetwerx.com> wrote: > > > I am using LIKE as the columns are indexed NOCASE and I need the > > comparison case insensitive. > > Have you tried using '=' ? > > Also if you declare the columns as COLLATE NOCASE in your table definition, > then using '=' will definitely work the way you want it to. An example would > be > > CREATE TABLE myTable (myName TEXT COLLATE NOCASE) Or create the index with collate CREATE INDEX idx_collated_column ON myTable ( column COLLATE NOCASE ) > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users