Hello,

we have a column in a table, called tag numbers, which start with numerical and alpha characters, IE:

012345
123456
LH12345
KB055698
47899901
MO558585
....... etc.

now what I need to do is to display all the tag numbers, but order by their alpha prefix, either DESC or ASC. What is the correct syntax to order by the alpha characters, first??

TIA,

Mike(mickalo)Blezien
===============================
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===============================

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to