Link to home
Create AccountLog in
Avatar of ouestque
ouestqueFlag for United States of America

asked on

Access 2007 query: sorting text numbers

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.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer