> On Jan 11, 2017, at 1:34 PM, R Smith <rsm...@rsweb.co.za> wrote: > > SELECT a FROM t WHERE a = b COLLATE NOCASE;
D’ohh! I overlooked the COLLATE operator. Perfect. (In my situation, these strings are not coming directly from columns, so setting collation on columns doesn’t make sense.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users