On 3 Nov 2013, at 3:24am, SongbookDB <shaun_thom...@songbookdb.com> wrote:
> WHERE Language !="" COLLATE NOCASE > ORDER BY Language COLLATE NOCASE) By the way, if every time you refer to your Language column you want it colated NOCASE, it's far more efficient to do it when you define the column in the table. CREATE TABLE ... (..., Language TEXT COLLATE NOCASE, ...) Then all collations of that column are handled NOCASE and you don't have to keep specifying it in your code or even indexes. Note that this does not change the actual values which are stored in the table: you still get back out the exact form of text you put in. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
