去除特殊的字符方法用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
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