Chris Miller Blog

RocketScientist's Miscellaneous Ramblings

IsNumeric('.')

So, anybody know why if you do this:

print IsNumeric('.')

it prints out this:

1


Seems that it won't convert to a float, it won't convert to an int, but it will throw lots of great errors…..

Legacy Comments


Mike
2011-03-02
re: IsNumeric('.')
Try converting is to money

Mike
2011-03-03
re: IsNumeric('.')
I commented on this yesterday! Try converting it to data type money.

chrism
2011-03-03
re: IsNumeric('.')
Yeah, that works. It's dumb, incredibly dumb, but it works.

So you can do this:

select isnumeric('.')
and you get 1.

You can also do:
select convert(float, convert(money, '.'))

and get 0 out.

Wow, that's just really really stupid.