Posted by Madhivanan on 07/11/06 14:55

Isnumeric is not reliable
http://aspfaq.com/show.asp?id=2390

Madhivanan


Erland Sommarskog wrote:
> (jaawaad@gmail.com) writes:
> > Actually i was looking for something like ISNUMERIC. I just wanted to
> > pull out rows that contains only numbers and just eliminate the others
> > with chars in them.
>
> isnumeric() is probably not what you want. It returns 1 if the string
> can be converted to any numeric data type. For instance, try
> SELECT isnumeric('1E0')
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@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

[Back to original message]