da-zero (9/27/2010)
tommyh (9/27/2010)
And yes i dont think $1 should count as numeric. $ is a currency symbol not a number.+ / * - % are arithmetic operators, not numbers. So 1+1 should still be rejected in your opinion.
It is. ISNUMERIC('1+1') returns 0. And that makes sense, because '1+1' does not convert to any of the numerical data types. A + (or -) is only permitted before the first number character. (Actually, the rule is a bit more complex than that). You can convert '+123' or '-123' to numeric, but not '12+3' or '12-3'.