I have a fairly simple table and all the fields are SHORT TEXT. Most field contain just numbers.
I have a query to select some records and the query has ORDER BY "Field5" (say).
If all the selected records have the same number of digits in Field5 then the order is correct. But if records have Field5 with different numbers of digits (e.g. a set of records has 1,2,3,....,10,11,....20,.....) then the Query returns
1 then 10, 11 etc then 2, then 21 - 29 then 3 then 30 etc.
Is there anyway to force the ORDER BY to the "correct" order??