复制代码 代码如下: —去除字符串中重復的值函數 create function StringRemove(@str nvarchar(2000)) returns varchar(2000) as begin declare @result nvarchar(2000),@temp nvarchar(1000) set @result=” set @temp=” while(charin
复制代码 代码如下: —去除字符串中重復的值函數 create function StringRemove(@str nvarchar(2000)) returns varchar(2000) as begin 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 @result end GO –(‘塗聚文’,’塗’,’塗聚文’,’1′,’23’,’1′) –測試 select dbo.StringRemove(‘塗聚文,塗,塗聚文,1,23,1’)
