Home Forums SQL Server 2005 T-SQL (SS2K5) Need to convert a SQL field based on delimiter RE: Need to convert a SQL field based on delimiter

  • April 9, 2015 at 2:33 pm

    #1790007

    I don't fully understand what you are trying to do but the splitter referenced in my signature line is the best way to split a string. This should get you started:

    Select ObjectID, Item AS author, Authors, Owners

    From Test

    CROSS APPLY dbo.DelimitedSplit8K(authors,'|')

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001