CSV to Table Conversion

DECLARE @string varchar(250), @delim char(1)

SET @string = '1,12,15,875,100,9'

SET @delim = ','

CREATE TABLE #result(Element int)

DECLARE @sql varchar(4000)

SELECT @sql = 'INSERT INTO #Result SELECT ' + REPLACE(@string, @Delim, ' UNION ALL SELECT ')

exec (@sql)

SELECT * FROM #result

DROP TABLE #result