Posted by Erland Sommarskog on 09/27/71 11:52

(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]