declare @s varchar(50) declare @varbin int declare @Temp varchar(1) declare @i int set @i=1 set @s = 'sqlserver中半角转换 ' while @i<=Len(@s) begin set @Temp=Substring(@s,@i,1) if unicode(@Temp)=12288 set @Temp=' ' set @i=@i+1 end select @s
嗯。上面的简单 declare @s varchar(50) set @s = 'sqlserver中半 角转换 ' select @s=replace(@s,a,b) from ( select '' a,' ' b union all select '' a,' ' b ) a
半角空格unicode32
declare @s varchar(50)
declare @varbin int
declare @Temp varchar(1)
declare @i int
set @i=1
set @s = 'sqlserver中半角转换 '
while @i<=Len(@s)
begin
set @Temp=Substring(@s,@i,1)
if unicode(@Temp)=12288
set @Temp=' '
set @i=@i+1
end
select @s
declare @s varchar(50)
set @s = 'sqlserver中半 角转换 '
select @s=replace(@s,a,b)
from (
select '' a,' ' b union all
select '' a,' ' b
) a