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. |