get a substring value from string

  • Ronzo wrote:

    Fascinating discussions, but what was "wrong" with my solution? I heard stuff like it is not usable except on SQL 2022, but this IS the SQL 2022 forum, is it not? So why not use the 3rd parameter, and keep the other solutions down in the pre-2022 forums, where hopefully people not using 2022 are looking anyway. I'd think we'd want to learn and use 2022's new features/advantages and share them in this forum.

    It would be interesting if you would use the test harness I posted earlier, add your solution and post the results.

    😎

    I don't have SQL Server 2022 yet.

  • carsten.saastamoinen wrote:

    It is OK for me to be removed from different threads because I not agree?

    Absolutely not.  Where did that happen?  Was it on this this thread?  Was it the one that was "Removed as SPAM" just a couple of posts above?  I can have the WebMaster restore you can point it 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)

Viewing 2 posts - 46 through 46 (of 46 total)

You must be logged in to reply to this topic. Login to reply