本文介绍了从输入文本中分割数字的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的朋友, 我已经从输入文本中拆分了号码. 例如:输入值-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
更多推荐
从输入文本中分割数字
发布评论