比如在AAAA表中cust_id字段有如下数据
HR00005
HR00025
HR00036
HR00045
HR00100
现将以上数据变为
5,
25,
36,
45,
100
SELECT
LTRIM(RTRIM(stuff(substring(right(cust_id,4),2,4),1,patindex('%[^0]%',substring(right(cust_id,4),2,4))-1,'')))
FROM AAAA
原址:http://blog.sina.com.cn/s/blog_4a2bf2330101fm9m.html