帮忙写个游标！！！急

[dabaicai]

我有一个字符串如“asdad,etertertyrt,sdfsfsfsf，kskdlfl”,由逗号隔开，现在我给个数：如3，就得到sdfsfsfsf，2就得到etertertyrt，怎么写，感谢！！！！！

[pengdali]

create function getstrofindex (@str varchar(8000),@index int =0)
returns varchar(8000)
as
begin
declare @str_return varchar(8000)
declare @start int
declare @next int
declare @location int
select @start =1
select @next =1
select @location = charindex(',',@str,@start)
while (@location <>0 and @index > @next )
begin
select @start = @location +1
select @location = charindex(',',@str,@start)
select @next =@next +1
end
if @location =0 select @location =len(@str)+1
select @str_return = substring(@str,@start,@location -@start)
if (@index <> @next ) select @str_return = ''
return @str_return
end
go

--调用：
select dbo.getstrofindex('asdad,etertertyrt,sdfsfsfsf，kskdlfl',3)

[pengdali]

select dbo.getstrofindex('asdad,etertertyrt,sdfsfsfsf,kskdlfl',3)

[dabaicai]

哈哈，thank you!!!!!!!!!!!搞定，你的等级这么高，要不要分，不如再还给我吧！！！呵呵

[yangchaobj]

还有.....这么.....厉害的.....高手呢......5颗星。

叹为观止。