Home Forums SQL Server 2005 SQL Server Newbies Stripping out all non-numerical characters RE: Stripping out all non-numerical characters

  • December 25, 2012 at 9:01 pm

    #1571480

    Sachin 80451 (12/18/2012)

    1. I would prefer t-SQL as CLR is way beyond my understanding

    2. At the moment I'm not concerned about performance

    I whole heartedly agree with #1 above. I never agree with #2 above because they always come back about the performance problem that a given solution is having. The only thing you should be more concerned about than performance is accuracy and the two should be virtually tied as being the most important. If you think not, spend an hour or two looking at the thousands of performance issues people are asking about on this forum alone.

    --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)