取字符串中第一个出现的数字
2009-12-07 14:43 清海扬波 阅读(1200) 评论(0) 编辑 收藏 举报
代码 select data, substring(numbers,1,patindex('%[ ]%',numbers+' ')-1) as new_data from
(
select data,substring(data,patindex('%[0-9]%',data),len(data)) as numbers from
(
select 'CHQ: 10 780213' as data union all
select '************** 1 53' union all
select 'AMEX T.C.STORE 9' union all
select 'AMEX T.C.STORE 10 33' union all
select '375 17' union all
select 'PERSON' union all
select 'CARD 30 PAID'
) as t
) as t
(
select data,substring(data,patindex('%[0-9]%',data),len(data)) as numbers from
(
select 'CHQ: 10 780213' as data union all
select '************** 1 53' union all
select 'AMEX T.C.STORE 9' union all
select 'AMEX T.C.STORE 10 33' union all
select '375 17' union all
select 'PERSON' union all
select 'CARD 30 PAID'
) as t
) as t
