Hi. I am trying to create a SQL statement that sorts by a column that contains a mix of numbers and periods, but it doesn't seem to work properly.
The statement I use is: SELECT ItemNumber FROM Catalog ORDER BY ItemNumber For instance, here is how the list was sorted: 5.2.8 5.2 5.3 5.13 5.10 5.27 But it should be: 5.10 5.13 5.2 5.2.8 5.3 5.27 Are there any additional parameters you can specify or another method for sorting alphanumeric strings such as this? Thanks for your help, Camilo Rostoker --------------------------------------------------------------------- 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
