I have a series of expressions in a format
2A22AA33333-222
where I want to use an ORDER BY clause to sort results by the 5-digit serial number string represented by 3s above. The ID numbers appear in this format on all rows. Any suggestions? I am working in Access but trying to tweak the ORDER BY clause using the SQL View. Thank you for any help!