SQL Order question
513167Mar 12 2007 — edited Mar 12 2007Dear all,
My table have a field e.g. colA varchar2(2) which stored number. The data stored in this field like that: 88, 89, 90, 91, ...99, 00, 01, 02, ..., 08 etc.
I don't know how to order the number like that: 08, ..., 02, 01, 00, 99 ... , 91, 90, etc.
Any idea?
Thank you!
Regards.