Forum Stats

  • 3,734,034 Users
  • 2,246,862 Discussions
  • 7,857,003 Comments

Discussions

SQL Order question

513167
513167 Member Posts: 164
edited March 2007 in SQL & PL/SQL
Dear 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.

Comments

This discussion has been closed.