汉字符号过滤函数 

  1 Create FUNCTION [dbo].[MarkRemoveFunction] 
  2 (
  3     @TargetString varchar(max)
  4 )
  5 RETURNS varchar(max)
  6 AS
  7 BEGIN
  8     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'!','')
  9     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'"','')
 10     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'#','')
 11     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'$','')
 12     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'%','')
 13     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'&','')
 14     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'''','')
 15     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'(','')
 16     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,')','')
 17     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'*','')
 18     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'+','')
 19     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,',','')
 20     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'-','')
 21     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'.','')
 22     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,':','')
 23     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,';','')
 24     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'<','')
 25     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'=','')
 26     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'>','')
 27     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'@','')
 28     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'[','')
 29     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'\','')
 30     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,']','')
 31     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'^','')
 32     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'_','')
 33     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'`','')
 34     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'{','')
 35     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'|','')
 36     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'}','')
 37     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'~','')
 38     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｡','')
 39     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｢','')
 40     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｣','')
 41     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'､','')
 42     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'･','')
 43     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ﾞ','')  
 44     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ﾟ','')  
 45     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'、','')
 46     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'。','')
 47     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'，','')
 48     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'．','')
 49     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'・','')
 50     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'：','')
 51     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'；','')
 52     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'？','')
 53     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'！','')
 54     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'゛','')  
 55     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'゜','')  
 56     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'´','')
 57     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｀','')
 58     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'¨','')
 59     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＾','')
 60     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￣','')
 61     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＿','')
 62     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ヽ','')
 63     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ヾ','')
 64     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ゝ','')
 65     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ゞ','')
 66     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〃','')
 67     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'仝','')
 68     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'々','')
 69     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〆','')
 70     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〇','') 
 71     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ー','')  
 72     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'―','')
 73     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‐','')
 74     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'／','')
 75     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＼','')
 76     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'～','')
 77     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∥','')
 78     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｜','')
 79     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'…','')
 80     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‥','')
 81     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‘','')
 82     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'’','')
 83     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'“','')
 84     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'”','')
 85     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'（','')
 86     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'）','')
 87     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〔','')
 88     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〕','')
 89     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'［','')
 90     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'］','')
 91     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｛','')
 92     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｝','')
 93     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〈','')
 94     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〉','')
 95     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'《','')
 96     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'》','')
 97     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'「','')
 98     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'」','')
 99     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'『','')
100     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'』','')
101     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'【','')
102     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'】','')
103     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＋','')
104     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'－','')
105     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'±','')
106     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'×','')
107     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'÷','')
108     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＝','')
109     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≠','')
110     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＜','')
111     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＞','')
112     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≦','')
113     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≧','')
114     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∞','')
115     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∴','')
116     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♂','')
117     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♀','')
118     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'°','')
119     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'′','')
120     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'″','')
121     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'℃','')
122     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￥','')
123     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＄','')
124     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￠','')
125     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￡','')
126     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'％','')
127     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＃','')
128     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＆','')
129     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＊','')
130     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＠','')
131     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'§','')
132     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'☆','')
133     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'★','')
134     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'○','')
135     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'●','')
136     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◎','')
137     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◇','')
138     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◆','')
139     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'□','')
140     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'■','')
141     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'△','')
142     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'▲','')
143     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'▽','')
144     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'▼','')
145     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'※','')
146     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〒','')
147     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'→','')
148     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'←','')
149     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'↑','')
150     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'↓','')
151     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〓','')
152     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∈','')
153     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∋','')
154     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊆','')
155     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊇','')
156     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊂','')
157     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊃','')
158     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∪','')
159     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∩','')
160     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∧','')
161     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∨','')
162     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￢','')
163     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⇒','')
164     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⇔','')
165     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∀','')
166     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∃','')
167     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∠','')
168     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊥','')
169     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⌒','')
170     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∂','')
171     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∇','')
172     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≡','')
173     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≒','')
174     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≪','')
175     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≫','')
176     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'√','')
177     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∽','')
178     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∝','')
179     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∵','')
180     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∫','')
181     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∬','')
182     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'Å','')
183     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‰','')
184     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＃','')
185     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♭','')
186     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♪','')
187     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'†','')
188     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‡','')
189     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'','')
190     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◯','')
191     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'─','')
192     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'│','')
193     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┌','')
194     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┐','')
195     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┘','')
196     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'└','')
197     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'├','')
198     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┬','')
199     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┤','')
200     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┴','')
201     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┼','')
202     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'━','')
203     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┃','')
204     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┏','')
205     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┓','')
206     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┛','')
207     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┗','')
208     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┣','')
209     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┳','')
210     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┫','')
211     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┻','')
212     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'╋','')
213     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┠','')
214     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┯','')
215     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┨','')
216     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┷','')
217     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┿','')
218     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┝','')
219     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┰','')
220     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┥','')
221     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┸','')
222     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'╂','')
223 
224     RETURN @TargetString
225 END
View Code

 

posted @ 2015-12-30 14:36  Cyber9527  阅读(243)  评论(0)    收藏  举报