SQL过滤掉空格和其他特殊字符函数

SERVER SQL

--SQL过滤掉空格和其他特殊字符函数

crteate function dbo.GetCodeString(@SourceSql varchar(500))
 returns nvarchar(500)

as 
 begin
 declare @i int
 declare @ValidChar nvarchar(100)
 declare @temp nvarchar(500)
 set @ValidChar='0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'

set @i=0
 while @i<=LEN(@SourceSql)
 begin

if(charindex(substring(@SourceSql,@i+1,1),@ValidChar))>0
 begin
  if(@i=0)
  begin
   set @temp=substring(@SourceSql,@i+1,1)
  end
  else
  begin
   set @temp=@temp+substring(@SourceSql,@i+1,1)
  end
 end
 set @i=@i+1

end
 return @temp
 end

 --测试

--select dbo.GetCodeString('ST ror'' US')
--输出结果为STrorUS

 

oracle