第1个回答 2010-06-24
--测试数据:
declare @t table(s varchar(366))
insert into @t
select
'012月'
union all select
'06月'
--以下为查询语句,实际应用把表名和字段名改为实际即可
select substring(s,len(s) - PATINDEX('%[0-9]%',REVERSE(s)),2) as 结果
from @t
where PATINDEX('%[0-9]%',REVERSE(s)) > 0 and isnumeric(substring(s,len(s) - PATINDEX('%[0-9]%',REVERSE(s)),2)) = 1