List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:November 26 2007 7:17pm
Subject:Order by Mixed Alpha/Numeric
View as plain text  
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
=============================== 

Thread
Order by Mixed Alpha/NumericMike Blezien26 Nov