I have a table with a text field. (table is titled: "stuff". Field is titled: "stuffNumber)
"stuffnumber" field contains numbers and text.
What SQL do I need to sort the numbers in the "stuffnumber" field in descending order.
Note: when you try to sort numbers in a text field, numbers don't sort correctly... (I.e. 14.1 will go before 2 if sorting ascending order)
I want to do this in a single query if possible.