select ListNumber
from SellRecord
order by
CHARINDEX('-',ListNumber),
CONVERT(int,LEFT(ListNumber,CHARINDEX('-',ListNumber)-1)),
CONVERT(int,LEFT(ListNumber,CHARINDEX('-',ListNumber)-1)+1),
CONVERT(int,Right(ListNumber,CHARINDEX('-',ListNumber)-1))
order by语句可以使用下
order by 字段名1,字段名2....