ODBiC Discussion Board


Sorting

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.

Thanks

John


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.