Access sorting

[Anon]

Can anyone help me do a sort where part numbers go with Alpha first then numeric? We need the numeric to come after the alpha and the dash after the numeric.

Example:

A-1080-2
AFC80019-212
AYP-3A
A2YP-2A
B-1020-B-1-L
B-1078-2
B-1450-2
C1007-1

[vponz]

Try with spliting this field with something like this:
I suppose your field is called ALPHA.

$sSql = "SELECT CONCAT(LEFT(ALPHA, INSTR(ALPHA, '-') - 1), ";
$sSql .= " RIGHT(ALPHA, length(ALPHA) - INSTR(ALPHA, '-'))) AS ALPHA2 FROM TABLE ORDER BY ALPHA2";

Good luck