sql server过滤字符串中空格的自定义函数f_trimstr()

 去掉字符串中的所有空格，当把文件导入数据库中时这个函数很有用。备查

-----------------------------语法-----------------------------

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

-----------------------------调用-----------------------------

select  name = f_trimstr(name) from wj_wzbm