I just tried it and it works fine. It doesn't solve my similar problem, which is related to letters coming *before* numbers, but the parser doesn't reject it.
Wish I could offer a solution, but I'm not very knowledgable about MySQL internals & config. -Derek > -----Original Message----- > From: John Almberg [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 9:30 AM > To: Mysql > Subject: FW: SQL question > > > > Nope. I've tried every combination I can think of of these ideas. They all > give syntax errors. I don't think arithmatic is allowed in an ORDER BY > clause. Doesn't even work on an INT field. > > -- John > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php