Hi,

Use the following Function....

CREATE FUNCTION fn_getrowsfrmCSVstring(@str varchar(max))

returns @rtn table (id int identity(1,1),value varchar(2000))

As

Begin

Declare

@mstr varchar(max),@i INT,@len INT

SELECT @mstr=@str,@len=LEN(@str),@i=1

WHILE @i<@len

BEGIN

IF CHARINDEX(',',@str)>0

SELECT @STR=SUBSTRING(@str,1,CHARINDEX(',',@str)-1)

ELSE

Select @STR=SUBSTRING(@str,1,LEN(@str))

INSERT INTO @rtn SELECT @STR

SET @i=@i+LEN(@str)+1

SET @STR=SUBSTRING(@mstr,@i,@len)

END

Return

END