Home Forums SQL Server 7,2000 T-SQL SUBSTRING And CHARINDEX to find start/end of string RE: SUBSTRING And CHARINDEX to find start/end of string

  • October 2, 2012 at 8:40 am

    #1544415

    Eliza (9/30/2012)

    Hi all,

    I have a big long text string that can vary in lengh and contrain audit information about data that has changed in the database...

    Thanks

    Eliza

    Which version of SQL Server are you using?

    What datatype is the string? Is it a column value?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden