Hi , I have resent another message and corrected that my solution wouldn't work because I oversaw the numbers with more than one digit, like you said. Roger Baklund posted the right syntax for it :
-----Original Message----- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: sorting Try this: SELECT ... FROM SP_rooms ORDER BY room_no+0,room_no; -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:09 PM To: [EMAIL PROTECTED] Subject: Re[2]: sorting Hello Gurhan, Will it put 9a before 19b ? Wednesday, April 17, 2002, 4:51:14 PM, you wrote: GO> If you just do your query as "SELECT .... FROM SP_rooms ORDER BY room_no" it GO> will give you the results you want.. GO> Gurhan GO> -----Original Message----- GO> From: Dieter Munnik [mailto:[EMAIL PROTECTED]] GO> Sent: Wednesday, April 17, 2002 8:48 AM GO> To: [EMAIL PROTECTED] GO> Subject: sorting GO> Hi, GO> I'm looking for an easy way to select "room numbers" in a numerical/ GO> alphabetical sequence in Mysql GO> Ex : This is for a reservation system. Room numbers are stored in GO> table SP_rooms, column room_no. There are room numbers like GO> 1,2,6,9,5a,4,3,5b . . . ect. I would like them to be order in the correct GO> sequence like 1,2,3,4,5a,5b,6,7,8,9 . . . . . . GO> I want to just make a simple select that will do this for me GO> Kind regards GO> Dieter GO> --------------------------------------------------------------------- GO> Before posting, please check: GO> http://www.mysql.com/manual.php (the manual) GO> http://lists.mysql.com/ (the list archive) GO> To request this thread, e-mail <[EMAIL PROTECTED]> GO> To unsubscribe, e-mail GO> <[EMAIL PROTECTED]> GO> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GO> --------------------------------------------------------------------- GO> Before posting, please check: GO> http://www.mysql.com/manual.php (the manual) GO> http://lists.mysql.com/ (the list archive) GO> To request this thread, e-mail <[EMAIL PROTECTED]> GO> To unsubscribe, e-mail <[EMAIL PROTECTED]> GO> 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