Sort numbers based on second digit

[Dale S]

I have a query where a field consists of 3 digit numbers. Normal sorting orders the numbers 117, 158, 217, 258, 317, 358, 417, and 458. How can I sort based on the second digit so the numbers are ordered 117, 217, 317, 417, 158, 258, 358, 458?

[Bob Fitz]

This will work for 3 diget numbers:
ORDER BY Right([num],2);