Hugo Kornelis (9/27/2010)
da-zero (9/27/2010)
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.
Dammit. I knew I should've test it before I made such a statement. 🙂
My point was that although + is not a number, the result of the expression 1+1 is a number. So I meant 1+1 as an expression, not '1+1' as a string.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP