13 December 2013

Split csv entries from a column in a table

This is all in a single query without having to create a function. The separator is in a cte so doesn’t need to be declared separately. For longer separators include the length in this cte and use it for the length adjustments in the query.

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

This post has been viewed 5198 times – thanks for reading.

  • Rate
    [Total: 0    Average: 0/5]
  • Share

Pop Rivett

View all articles by Pop Rivett