Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Why doesn’t ISNUMERIC work correctly? (SQL Spackle) RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

  • November 30, 2010 at 10:26 pm

    #1257144

    sharath.chalamgari (11/30/2010)

    Simple and nice article,

    some time back i was working on validating a column in the database and i came across this issue and we had this function to validate.

    Thanks for the feedback and the code example, Sharath. That's one of the really good things about having the "discussion area" even on short articles. Goodies like what you posted come right out.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)