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