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) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users