| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
12-05-2006, 11:55 PM
|
|||
|
|||
Access dialect question:
How do I sort results using ORDER BY?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!     
|
