取字符串中第一个出现的数字

最新推荐文章于 2021-07-30 10:37:15 发布

weixin_30326741

最新推荐文章于 2021-07-30 10:37:15 发布

阅读量612

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/q123126/archive/2009/12/07/1618597.html

代码

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

转载于:https://www.cnblogs.com/q123126/archive/2009/12/07/1618597.html