Script for Convert Delimited String to Column in Microsoft SQL Server

Create a function for convert delimited string to Column row data:

CREATE FUNCTION cmt_data_user.Split(@String varchar(max), @Delimiter char(1))
returns @temptable TABLE (items varchar(max))
as
begin
declare @idx int
declare @slice varchar(max)

select @idx = 1
if len(@String)0)
insert into @temptable(Items) values(@slice)

set @String = right(@String,len(@String) - @idx)
if len(@String) = 0 break
end
return
end

For Output:

select * from dbo.split('aaa,bbb,ccc',',');

Result:
-------
aaa
bbb
ccc