Andreas Wicker <awic...@nero.com> wrote: > A simple query like this works fine with both versions, the result is sorted > NOCASE by the Album column:
Purely by accident of implementation. No particular order of rows in the resultset is guaranteed, unless there's an ORDER BY clause. If you rely on a particular order, specify it explicitly. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users