Sql: 去除字符串中的相同的字符串函數

---去除字符串中重復的值函數create function StringRemove(@str nvarchar(2000))returns varchar(2000)asbegin    declare @result nvarchar(2000),@temp nvarchar(1000)    set @result=''    set @temp=''    while(charindex(',',@str)<>0)        begin            set @temp=substring(@str,1,charindex(',',@str))               if(charindex(@temp,@result)<=0)                           set @result=@result+@temp                   set @str=stuff(@str,1,charindex(',',@str),'')        end    return @resultendGO--('塗聚文','塗','塗聚文','1','23','1')--測試select dbo.StringRemove('塗聚文,塗,塗聚文,1,23,1')