• 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