ordering values

How do i order numbers retrieved by there value, such as: 1,2,3,4,5...12,13...22 so its like that instead of 1,11,12,13,14,2,21,22,23,24,31,4,5,6...

thankds

you would use an integer (INT) or other numeric type for your data column instead of using a string type like CHAR or VARCHAR which is what you have used.

you would use an integer (INT) or other numeric type for your data column instead of using a string type like CHAR or VARCHAR which is what you have used.
using a time but its custom, so i cant use a time field, crap was hoping i could just use some function to put it in order.

if those are TIME values why can't you use TIME to store them in? what is preventing you from doing so?