Home Forums SQL Server 2008 SQL Server 2008 - General do you have a StripNonNumeric ITVF function? RE: do you have a StripNonNumeric ITVF function?

  • October 30, 2014 at 9:58 pm

    #1755959

    Now we're cooking with gas! Well done! I had eye surgery today (lens replacement) and can't see so well yet and can't spend much time in front of the computer but I'll run some additional tests over the weekend using variable length data and see what happens.

    We also need to try the same thing on Alan's good pattern matching code.

    As Eirikur suggests, this is an example of the SQL Server Community (same initials as SQL Server Central :-)) at it's best. Keep 'em coming folks!

    BTW, that's one heck of a nice machine you have there, Eirikur!

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