BUG - ISNUMERIC('.') = 1

10 Feb 2006 9:36 PM

Howard Swope

ISNUMERIC('.') returns a value of 1.

This is bad, right?

Howard

10 Feb 2006 9:38 PM

Aaron Bertrand [SQL Server MVP]

http://www.aspfaq.com/2390

Show quote

"Howard Swope" <swopehATgigamotoDOTcom> wrote in message
news:eockploLGHA.3100@tk2msftngp13.phx.gbl...
> ISNUMERIC('.') returns a value of 1.
>
> This is bad, right?
>
> Howard
>
>

10 Feb 2006 9:50 PM

Bob Barrows [MVP]

Howard Swope wrote:

> ISNUMERIC('.') returns a value of 1.
>
> This is bad, right?
>

Try this to see why isnumeric returns 1 for this string:
select cast('.' as money)

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

10 Feb 2006 11:26 PM

Erland Sommarskog

Howard Swope (swopehATgigamotoDOTcom) writes:

> ISNUMERIC('.') returns a value of 1.
>
> This is bad, right?

Yes isnumeric() is bad. It returns 1 if the value can be converted to
any numeric data type. Which is quite a useles piece of information.

It's not a bug though.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx