我有下面的样本数据,我正在try 提取字符串中的最后一个数字.我有以下几点,这让我在一定程度上做到了这一点,但我不确定如何在不是最终结论的地方获得值.
right(TextDescription, patindex('%[^0-9]%',reverse(TextDescription)) - 1)
结果应该是:
ID | code |
---|---|
1 | 10015662 |
2 | 100040344 |
3 | 10015370 |
4 | NULL |
5 | 400337 |
样本数据
Create Table #TestData
(
ID int,
TextDescription varchar(100)
)
insert into #TestData Values (1,'Data From JOE BLOGGS 10015662 tree 10015662')
insert into #TestData Values (2,'Fast Data From JOHN SMITH 10004034 MARY SMITH 100040344 plant')
insert into #TestData Values (3,'Data In 10015370 pot JONES')
insert into #TestData Values (4,'Fast Data From LEE tree')
insert into #TestData Values (5,'Direct Data 106600 JANE GREEN 400337')