我想要一个只返回数字的查询. [英] I want a query which should return only numbers.

问题描述

我想要一个查询，该查询必须只给定给定字符串的数字.给定字符串是字母，数字，符号，特殊字符的组合.无论给定的字符串是什么，它都应仅返回数字.

例如:

声明@string varchar(max)
选择@string =``abc9-82nm @ $％''

期望输出为982.

在此先感谢.

Hi,
I want a query which must give me only numbers for the given string.The given string is a combination of alphabets,numbers,symbols,special characters. Whatever may be the given string it should return only numbers.

For Example:

Declare @string varchar(max)
select @string = ''abc9-82nm@$%''

The desire output is 982.

Thanks in advance.

推荐答案

％''

期望输出为982.

预先感谢.

%''

The desire output is 982.

Thanks in advance.

您好，请检查这些sql函数，

http://blog.sqlauthority.com/2007/04/11/sql-server-udf-user-defined-function-to-extract-only-numbers-from-string/ [

Hi check these sql functions,

http://blog.sqlauthority.com/2008/10/14/sql-server-get-numeric-value-from-alpha-numeric-string-udf-for-get-numeric-numbers-only/[^]

http://blog.sqlauthority.com/2007/04/11/sql-server-udf-user-defined-function-to-extract-only-numbers-from-string/[^]

DECLARE @strAlphaNumeric varchar(max)
SET @strAlphaNumeric = 'abc9-82nm@

这篇关于我想要一个只返回数字的查询.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！