SQL to split comma separated values

SQL to split comma separated values

SELECT [Column1],
LTRIM(RTRIM(m.n.value('.[1]','varchar(4096)'))) AS [Column2]
FROM
(
SELECT  [Column1],CAST('<XMLRoot><RowData>' + REPLACE(Column2,',','</RowData><RowData>') + '</RowData></XMLRoot>' AS XML) AS x
FROM   [TableName]
)t
CROSS APPLY x.nodes('/XMLRoot/RowData')m(n);