SQL 如何去除重复的字符串

方案一：

declare @ret varchar(8000)
select @ret = 'APR-11,APR12,APR06,APR-11,APR12,APR06'

select distinct name=substring(@ret,number,charindex(',',@ret+',',number)-number)
from master..spt_values
where number<=len(@ret) and type='P' 
and substring(','+@ret,number,1)=','
--------------------------
APR06
APR-11
APR12
declare @ret varchar(8000)
select @ret =