Christian Buettner (8/10/2009)
Hi Kevin,I think that is not true.
Try
select isnumeric('$$')for example.It will evaluate to false, although this character ($) was no issue in your previous example.
The reason why your example is returning true, is probably the fact that it can be cast to (small)money.
My mistake. Thanks for pointing this out. I always thought this function just didn't work properly. Now I see I just didn't understand it's purpose. Any idea why Microsoft didn't implement ISMONEY() ISINT() or ISFLOAT()? ISNUMERIC() seems almost useless for testing before an insert.