Home Forums SQL Server 2008 T-SQL (SS2K8) Split a String RE: Split a String

  • March 12, 2013 at 12:19 pm

    #1596220

    ChrisM@Work (3/12/2013)

    AndrewSQLDBA (3/12/2013)

    I was actually looking for something else. That really did not help.

    Andrew SQLDBA

    What's the problem with it, Andrew? There is an alternative; I'm just curious.

    the default DelimitedSplit8K is limited to a single char delimiter, which is one tripwire, since he's got dbl pipes for the delimiter. so he'd have to adapt it, or find-and-replace the dbl piple with a single char, and either solution might not be obvious.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!