sqlserver过滤字符串中的空格的自定义函数

去掉字符串中的所有空格

CREATE    Function f_trimstr(@str varchar(100))

returns varchar(100)

AS

begin

declare @i int
declare @s1 varchar(50)
declare @result varchar(100)
declare @len int

select @result = ''
select @str = ltrim(rtrim(@str))
select @len = len(@str)
select @i = 1

while @i<=@len
begin
 select @s1 = substring(@str,@i,1)
 if(@s1<>'')
  begin
  select @result = @result + @s1
  end
 select @i = @i + 1
end

return @result

end