From: Mike Blezien (mickalofrontiernet.net)
Date: Mon Nov 26 2007 - 13:17:03 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]