Results 1 to 11 of 11
Dec 14, 2009, 08:47 #1
ORDER BY problems depending upon type
I want my query to ORDER BY number, but I have a problem...
I have the following numbers...
I my number column is of type int, I lose the "T" in 28T.
If I make it of type CHAR, it orders it as follows:
1, 22, 28T, 4
4 should be before 22. Can anyone help with this? One way I can get it to work is to keep it as a CHAR and enter 1 and 4 as 01 and 04, but i don't want to have to do that.
Anyone?Restaurant Takeout & Delivery Menus : Over 4500 Menus Online
Athletic Recruiting & Community for High School Athletes!