Lukasz.Stela wrote: >The following query returns an error "1st ORDER BY term does not match >any column in the result set".
This restriction comes from the SQL standard. >When I replace the UPPER (Name) by Name - everything works correctly. In theory, it would be possible to sort by something that can be derived from some column in the result set. But that is not implemented in SQLite. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users