取字符串中第一个出现的数字
2009-12-07 14:43 清海扬波 阅读(1202) 评论(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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步