PDA

View Full Version : ordering values



jeromepelletier
08-24-2006, 06:30 PM
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

guelphdad
08-24-2006, 11:45 PM
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.

jeromepelletier
08-27-2006, 04:31 AM
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.

guelphdad
08-27-2006, 03:42 PM
if those are TIME values why can't you use TIME to store them in? what is preventing you from doing so?