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