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. What you are looking for is a function that tests if a given expression matches the pattern '[0-9]' for every character. That is not what isnumeric() is intended for (as Hugo already mentioned). It is similar to complaining that a hammer cannot tighten a screw.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP