by John Kincaid, February 29, 2004 16:24
I have sorting problem that maybe someone could help with. The numbering scheme my access database for car models uses is: D-18 D-19 D-20 etc. then D2-01 D2-02 D2-03 D2-20 The problem is that a SQL SELECT sorts the numbers as: D-18 D-19 D-20 D2-01 D2-02 then D2-09 then D-21. I would like it sorted with all the D's together then D2's and so on.
Name E-mail optional TopicMessage:
HTTP Link: Link text: