1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

How do I sort results using ORDER BY?

Discussion in 'SQL - Questions and Answers' started by Brian, Dec 6, 2006.

  1. Brian Guest

    Dialect: Access
    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!
    Brian, Dec 6, 2006
    #1

  2. Dimitar Guest

    Can't you order by a substring?
    Dimitar, Dec 13, 2006
    #2

Share This Page