SQLServer 替换特殊符号


SQLServer 替换特殊符号

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
ALTER FUNCTION [dbo].[filterStr]
(
    -- Add the parameters for the function here
    @Str  varchar(500)
)
RETURNS  varchar(500)
as  
begin  
  declare @Nstr varchar(500)  
    set @Nstr=@Str
    set @Nstr = Replace(@Nstr,'\r', '')
    set @Nstr = Replace(@Nstr,'\n', '')
    set @Nstr = Replace(@Nstr,'?', '')
    set @Nstr = Replace(@Nstr,'\r', '')
    set @Nstr = Replace(@Nstr,',', '')
    set @Nstr = Replace(@Nstr,'，', '')
    set @Nstr = Replace(@Nstr,' ', '')
    set @Nstr = Replace(@Nstr,'"', '')
    set @Nstr = Replace(@Nstr,'', '')
    set @Nstr = Replace(@Nstr,'\t', '')
    set @Nstr = Replace(@Nstr,'/r', '')
    set @Nstr = Replace(@Nstr,'\n\r', '')
    set @Nstr = REPLACE(@Nstr,'"','')
    set @Nstr = REPLACE(@Nstr, CHAR(13), '')//替换回车符
    set @Nstr = REPLACE(@Nstr, CHAR(10), '')//替换换行符
    return @Nstr
end