去除特殊的字符方法用replace()函數

--**************去除特殊的字符方法用replace()函數*****************************************
declare @st varchar(100)
select  @st=',asdf,,,,,,,,,asdf,  xx'+char(32)+'yy'+char(13)+'zz'+char(10)+'pp'+char(9)+'tt,'
print @st
select @st=replace(replace(replace(replace(@st,char(32),''),char(9),''),char(10),''),char(13),'')
while @st<>replace(@st,',,',',')
begin
    select @st=replace(@st,',,',',')
    print '--'+@st
end
if left(@st,1)=','
begin
    select @st=right(@st,len(@st)-1)
    print '--'+@st
end
if right(@st,1)=','
begin
    select @st=left(@st,len(@st)-1)
    print '--'+@st
end

转载于:https://www.cnblogs.com/gungun/archive/2007/11/15/960364.html