汉字符号过滤函数

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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步