1

Possible Duplicate:
T-SQL: Opposite to string concatenation - how to split string into multiple records
Split Function equivalent in tsql?
How Do I Split a Delimited String in SQL Server Without Creating a Function?

Let's say I have a varchar with the following value: 

'1:2:3:4:5'

I would like to write a select statement, with the result of:

1
2
3
4
5

Is this possible? Thanks.

Community
  • 1
  • 1
Lajos Arpad
  • 64,414
  • 37
  • 100
  • 175
  • 2
    Many dups if you search for *[t-sql] split* E.g. http://stackoverflow.com/questions/314824/t-sql-opposite-to-string-concatenation-how-to-split-string-into-multiple-reco – Alex K. Dec 21 '12 at 15:07
  • See this duplicate http://stackoverflow.com/q/3097864/175679 using XML or UDF – SliverNinja - MSFT Dec 21 '12 at 15:08

0 Answers0