SqlServer数据库截取字符串，获取字符串前后的值

declare @sql varchar(5000),@totalLength int,@length int,@tag varchar(20),@currentNumber int
set @sql='a,v,c,'
print @Str
set @tag='，'
set @totalLength=len(@sql)
set @length=charindex(@tag,@sql)
print '第1条记录:'+left(@sql,@length-1)
if(left(@sql,@length-1)>0)
begin
set   @ret=1
end
set @sql=substring(@sql,@length+1,@totalLength)
set @currentNumber=1
while (@length>0)
begin
set @currentNumber=@currentNumber+1
set @length=charindex(@tag,@sql)
if(@length=0)
begin
break;
end
print '第'+ltrim(str(@currentNumber))+'条记录:'+left(@sql,@length-1)
set @sql=substring(@sql,@length+1,@totalLength)
end