Yes, that works! Thank you very much! -- John
> -----Original Message----- > From: Mark Matthews [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 1:33 PM > To: John Almberg > Cc: Mysql > Subject: Re: FW: SQL question > > > 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 > > > > > Have you tried a computed column, i.e, > > SELECT BLAH, 0 + BLAH as orderByColumn ORDER BY orderByColumn ASC > > -Mark > > -- > For technical support contracts, visit https://order.mysql.com/?ref=mmma > > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java > /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA > <___/ www.mysql.com > > > --------------------------------------------------------------------- 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