Hi,
I am using MS-SQL 2000. I had a varchar column with data formated as Numeric portion + Alpha portion.
Id
----
1
2AA
2DF
2AB
22A
444CD
11
etc..
I like to sort the column first with the numeric portion then with the alpha portion like follows.
1
2AA
2AB
2DF
11
22A
444CD
Regards,
Shijith
Did you try a ORDER BY <column name>
the order by generally happens based on the ascii value of the alphabets.
A - 65 followed by B,C,D etc.
Could you please POST the output of the ORDER BY query here?
