comma separated values to rows in sql server

Hi Rohan Gupta,

create function [dbo].[ufn__SplitString]

(@str varchar(100),@delim varchar(10))

returns @table table(value varchar(50))

BEGIN

declare @value varchar(50)

set @value=''

while(CHARINDEX(@delim,@str)!=0)

BEGIN

select @value=SUBSTRING(@str,1,CHARINDEX(@delim,@str)-1)

select @str=SUBSTRING(@str,CHARINDEX(@delim,@str)+1,LEN(@str))

insert into @table values(@value)

END

insert into @table values(@str)

return

END

select * from dbo.[ufn__SplitString]('abc,123,xyz,rajulu', ',')