对你来说很简单,帮帮我,在线等
SELECT code FROM customer where SUBSTRING(code, 1, 1)= 'A ' order by code desc;

'ABCD '
'A0001 '

我需要排出掉以字母A开头后面不是数字的记录,比如 'ABCD '，请问该怎么做，谢谢了

[解决办法]
selectcode FROM customer where SUBSTRING(code, 1, 1)= 'A ' and ISNUMERIC(right(code,len(code-1))) <> 1