SQL "Order By" problem
I have an Access database with one table that contains a number of fields. I use the database with Visual Basic 6.0. One of the fields (CustNumber) contains a sequence that I need to show up in a specific sorted order, but a simple "Order By" doesn't work for me. The data in that field consists of one of two combinations. It will be either a "N" + a "number" OR a "N" + a "number" & a "B" + a "number"; such as N14 OR N3B12.
The first example is what I have, the second example is what I get after my Select statement and the third example is what I need to really end up with. Any help would be appreciated.
My Select statement is:
Select * From TABLE Order By CustNumber
Example 1. Starting data ----->
CustNumber
N1
N21B7
N4B1
N31B81
N4B5
N4
N21
N31
N31B6
N50
Example 2. After the "Order By"
N1
N4
N21
N31
N50
N4B1
N4B5
N21B7
N31B6
|
