Igor Tandetnik schrieb: > "Lukas Haase" <lukasha...@gmx.at> wrote in > message news:gkd3f4$cl...@ger.gmane.org >> This is not what I want. So I use COLLATE NOCASE: >> >> This is the result I want. However, now I need a WHERE clause to work >> exactly the same. So I tried: >> >> SELECT keyword FROM keywords WHERE keyword < 'T*' ORDER BY keyword >> COLLATE NOCASE ASC; > > SELECT keyword FROM keywords > WHERE keyword < 'T*' COLLATE NOCASE > ORDER BY keyword COLLATE NOCASE ASC; > > Or, you could just specify the collation in the CREATE TABLE statement, > then it would be used by default both for comparisons and for sorting: > > CREATE TABLE keywords( > keywordID INTEGER PRIMARY KEY, > keyword VARCHAR(100) COLLATE NOCASE > );
Thank you very much! :-) Luke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
