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 > > if this is not quit right try > > ORDER BY 0 + fieldname , fieldname > > John Almberg wrote: > > >That gives a syntax error, unfortunately. > > > >-- JOhn > > > > > > > >>-----Original Message----- > >>From: Mihail Manolov [mailto:[EMAIL PROTECTED]] > >>Sent: Thursday, September 26, 2002 9:51 PM > >>To: Mysql > >>Subject: Re: SQL question > >> > >> > >>Try: > >> > >>SELECT fieldname FROM table ORDER 0+fieldname; > >> > >> > >>Hope it helps. > >> > >> > >>Mihail > >> > >>----- Original Message ----- > >>From: "John Almberg" <[EMAIL PROTECTED]> > >>To: "Mysql" <[EMAIL PROTECTED]> > >>Sent: Thursday, September 26, 2002 8:04 PM > >>Subject: SQL question > >> > >> > >> > >> > >>>I'm trying to sort a table on a character-type field that > >>> > >>> > >>contains mostly > >> > >> > >>>numbers. This field always contains either a number or a > number followed > >>> > >>> > >>by > >> > >> > >>>a character. Like '57' or '57a'. > >>> > >>>I'd like to sort the table *numerically* on this field, not > >>> > >>> > >>*alphabetically* > >> > >> > >>>on this field. That is, I'd like the table to be sorted like: > >>> > >>>1 ... > >>>2 ... > >>>2a ... > >>>3 ... > >>>4d ... > >>> > >>>NOT like: > >>> > >>>1 ... > >>>11 ... > >>>111a ... > >>>2a ... > >>>22 ... > >>> > >>>See what I mean? This is a common problem, I think, when you sort an > >>>character type field that contains numbers. The sort comes out > >>> > >>> > >>all wrong. > >> > >> > >>>Is there anyway I can achieve this sort using SQL? The target server is > >>>running 3.22.32. Any ideas greatly appreciated! > >>> > >>>-- 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 > >> > >> > >> > > > > > >--------------------------------------------------------------------- > >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 > > > > > > > > > > --------------------------------------------------------------------- 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