Ok, i´ve found the key... :-) ORDER BY coalesce(fi.name, 'ZZZZZ') desc Regards, ecc emuControlCenter - http://www.camya.com/ecc/ -- View this message in context: http://www.nabble.com/collation---order-null-values-to-end-of-result-tf2026443.html#a5575844 Sent from the SQLite forum at Nabble.com.
