Home Forums SQL Server 2005 SQL Server 2005 General Discussion Trying to iteratively use PATINDEX commands to comb through a large amount of text RE: Trying to iteratively use PATINDEX commands to comb through a large amount of text

  • December 19, 2010 at 1:24 am

    #1264425

    First things that pop in to my head:

    1. CTE to identify occurrences of the desired string part

    2. Table valued function using the CTE and then using CROSS APPLY

    Perhaps others have better ideas?