ORDER BY issue
Posted: Wed Feb 13, 2008 10:45 am
Hey all,
I order by a text field when pulling out with a certain query. The problem is, a lot of the results start with numbers, and look like this when the query is run:
I really don't want to split those with numbers into another column and double sort, that seems messy to me...
I order by a text field when pulling out with a certain query. The problem is, a lot of the results start with numbers, and look like this when the query is run:
Is there a way to order it like this:1 Division
110 Division
12 Division
2 Division
Test Division
Z Division
It's just a standard varchar, but ordering is not the numerical way1 Division
2 Division
12 Division
110 Division
Test Division
Z Division