MSSQL ISNUMERIC - Is it?

I didn't realise that ISNUMERIC('123 £') returns 1 - did you? If you didn't either then I'd suggest you read this article Why doesn't ISNUMERIC work correctly? by Jeff Moden on SQLServerCentral.com.

Taken from the article, the easiest test is to use a regular expression:

SELECT *
FROM mytable
WHERE mytable.mycolumn NOT LIKE '%[^0-9]%'

There is also a useful function he has written that could prove to be handy.

Thanks Jeff. Think I'd better re-trace some steps to make sure scripts using ISNUMERIC are a bit tighter!