从输入文本中分割数字 [英] split number from input text

问题描述

亲爱的朋友，

我已经从输入文本中拆分了号码.
例如:输入值-Test123456this789code10
我只希望显示数字，例如12345678910
我需要从SQL端开始执行此操作，请指导我.

问候，
AP

Dear Friends,

I have split number from input text.
Eg: Input Value - Test123456this789code10
I want only numbers be displayed like 12345678910
I need to do this from SQL end, Kindly guide me.

Regards,
AP

推荐答案

通过使用PATINDEX

例如:

By using a PATINDEX

EX:

Declare @Temp Table(Data VarChar(20))

Insert Into @Temp Values('BTA200')
Insert Into @Temp Values('BTA50')
Insert Into @Temp Values('BTA030')
Insert Into @Temp Values('BTA')
Insert Into @Temp Values('123')
Insert Into @Temp Values('X999')

Select Data, Left(Data, PatIndex('%[0-9]%', Data + '1') - 1)
From   @Temp

检查此链接:
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server [ ^ ]


干杯

Check this link:
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server[^]


Cheers

这篇关于从输入文本中分割数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！