Then try: select somefields,fieldname + 0 as orderfield order by orderfield
John Almberg wrote: >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 > > > >>-----Original Message----- >>From: gerald_clark [mailto:[EMAIL PROTECTED]] >>Sent: Friday, September 27, 2002 9:52 AM >>To: John Almberg >>Cc: Mysql >>Subject: Re: SQL question >> >> >>ORDER BY 0 + fieldname >> >> >> --------------------------------------------------------------------- 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
