Yes, that worked. Thanks to all who contributed similar solutions! Now I'm going to mention MySQL in my message so that my message isn't rejected as spam by the list manager! (What's that all about???)
Thanks again (mentioning MySQL again (just to be safe)) -- 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