Scott Hamm wrote:
How do I use ORDER BY in a way that it list null last after Z instead of before A?I.e. instead of: Null, A, B, C.... result would be: X, Y, Z, null How can I get around to that?
Something like ORDER BY IF(col IS NULL, 1, 0), col Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]