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

代码

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