Hi, i have the problem with a search-result order.
select * from files left join meta_data on files.id=meta_data.id order by meta_data.title asc, files.title asc Ok, ther is no meta-data for every files, so the join result for meta_data.title asc is NULL. So, every results with no meta-data are ordered to the beginning of the result-set.... not fine, because results with meta-data have priority in my order by. How can i change the collation sequence to get num -> string -> null? Regards, andreas http://www.camya.com/ecc/ -- View this message in context: http://www.nabble.com/collation---order-null-values-to-end-of-result-tf2026443.html#a5572595 Sent from the SQLite forum at Nabble.com.