返回数字的SQL [英] SQL that returns a numeric
本文介绍了返回数字的SQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
我想要检索一个数据来自带有数值的子字符串
ex。
561-265-262665
656-01D-054548
355-2D0-000048
656-656-465656
636-412-112313
我的查询
SELECT 子串(BCode, 5 , 3 ) FROM 表
结果是
265
01D
2D0
656
636
如何过滤
265
656
636
我试过REGEX但没有运气:(
解决方案
此链接将帮助您....
http://blog.sqlauthority.com/2008/10/14/sql-server-get-numeric- value-from-alpha-numeric-string-udf-for-get-numeric-numbers-only / [ ^ ]
这个链接对我有帮助:)
http://forums.mysql.com/read.php?60,1907,38488#msg-38488
您好iMaker ,
尝试以下代码,这对我有用。
SELECT SUBSTRING(Column1, 5 , 3 ) FROM TableName WHERE SUBSTRING(Column1, 5 , 3 )不 喜欢 ' %[^ 0-9]%'
我希望这能帮到你。
谢谢
Mohan G
Hi
I want to retrieve a data that From substring with a numeric value
ex.
561-265-262665
656-01D-054548
355-2D0-000048
656-656-465656
636-412-112313
on my Query
SELECT Subtring(BCode,5,3) FROM Table
the result are
265
01D
2D0
656
636
How can I filter for the result of
265
656
636
I've tried REGEX but no luck :(
解决方案
This link will help you....
http://blog.sqlauthority.com/2008/10/14/sql-server-get-numeric-value-from-alpha-numeric-string-udf-for-get-numeric-numbers-only/[^]
This link help me :)
http://forums.mysql.com/read.php?60,1907,38488#msg-38488
Hi iMaker,
try the below code, It's working for me.
SELECT SUBSTRING(Column1,5,3) FROM TableName WHERE SUBSTRING(Column1,5,3) not like '%[^0-9]%'
I hope this will help you.
Thank's
Mohan G
这篇关于返回数字的SQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文