sort field question
I have a table with numerical field I want to use for sorting for the results page. Field contains numbers like 20, 40, 100 etc. It works great until a field starts with 100. Then the numbers that start with 100 jump ahead of 20, 40, etc. I am assuming that the first number in the field is serving as the sorter. How can I make it use all three digits instead of the first digit?
ORDER BY tenant_location DESC
is the sort being used and results in
when I need to have