"order by" Question

[NitzGuy]

Hi,
I have a small problem with the "order by" in Postgresql. My problem is that I am tring to use the "order by" on characters and it works great until I get to numbers saved as characters then the order gets messed up (Just for the numbers). Is there a way I can fix this?

Thanks,
Jason Fournier

 

[richardpaulhall]

Do you mean yourresults are like:
1
11
12
2
21
22

That is how numbers get sorted ALPHABETICALLY.
Try storing numbers with leading 0s

01
02
11
12
21
22

Rick