关于排序(不按英文字母顺序排)的问题?

lhybird

能不能实现按以下顺序排序:

M1,M2,M3,E1,E2,E3,G1,G2,G3,A1,A2,A3

谢谢!

lhybird

谢谢andymark提供的方法.

myszh,你好!你的

SELECT Sheet1.MZ
FROM Sheet1
GROUP BY Sheet1.MZ
ORDER BY Left([MZ],1) DESC , Right([MZ],1);
里的DESC是什么意思?

lhybird

谢谢大家的帮助

lhybird

andymark 的sql

SELECT *
FROM Sheet1
WHERE MZ In ("M1","M2","M3","E1","E2","E3","G1","G2","G3","A1","A2","A3")
ORDER BY InStr(",M1,M2,M3,E1,E2,E3,G1,G2,G3,A1,A2,A3,","," & MZ & ",");

怎么才能在VB里使用?双引号和in,instr函数怎么办?