从输入文本中分割数字

本文介绍了从输入文本中分割数字的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

亲爱的朋友， 我已经从输入文本中拆分了号码. 例如:输入值-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

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

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