[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] collation - order null values to end of result
From:       ecc <ecc () camya ! com>
Date:       2006-07-31 13:35:40
Message-ID: 5575844.post () talk ! nabble ! com
[Download RAW message or body]


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.


[prev in list] [next in list] [prev in thread] [next in thread]