I guess I've never noticed that but why not just select more than one calculation such as:
SELECT sqrt(col) AS blarg, sqrt(col) + 1 AS order_blarg FROM table ORDER BY order_blarg its a work around but it should work fine -John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
