![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![ExpandedBlockStart.gif](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
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