--create
-- 去掉特殊符号
alter function RepSymbol(@str nvarchar(max))
returns nvarchar(max)
as
begin

set @str=LTRIM(@str)
set @str=RTRIM(@str)
set @str=replace(@str,char(9),'') --水平制表符
set @str=replace(@str,char(10),'') -- 换行
set @str=replace(@str,char(13),'') --回车
set @str = replace(@str,'π', 'π');
set @str = replace(@str,'∠', '∠');
set @str = replace(@str,'≠', '≠');
set @str = replace(@str,'≥', '≥');
set @str = replace(@str,'≤', '≤');
set @str = replace(@str,'α', 'α');
set @str = replace(@str,'|', '|');
set @str = replace(@str,'±', '±');
set @str = replace(@str,'∞', '∞');
set @str = replace(@str,'×', '×');
set @str = replace(@str,'$', '$');
set @str = replace(@str,''', '''');
set @str = replace(@str,'°','°');
set @str = replace(@str,'⊥','⊥');
set @str = replace(@str,'∪','∪');
set @str = replace(@str,' ',' ');
set @str = replace(@str,'&lt;','<');
set @str = replace(@str,'&isin;','”');
set @str = replace(@str,'&beta;','β');
set @str = replace(@str,'濛','濛');
set @str = replace(@str,'&ldquo;','“');
set @str = replace(@str,'&prime;','′');
set @str = replace(@str,'&Delta;','Δ');
set @str = replace(@str,'&middot;','·');
set @str = replace(@str,'&gt;','>');
set @str = replace(@str,'&darr;','↓');
set @str = replace(@str,'&rarr;','→');
set @str = replace(@str,'&bull;','•');
set @str = replace(@str,'&rdquo;','”');
set @str = replace(@str,'&omega;','ω');
set @str = replace(@str,'&shy;','');
set @str = replace(@str,'&uarr;','↑');
set @str = replace(@str,'&theta;','θ');
set @str = replace(@str,'&mdash;','—');
set @str = replace(@str,'—','—');
set @str = replace(@str,'&#36','$');
set @str = replace(@str,'▽','▽');
set @str = replace(@str,'&there4;','∴');
set @str = replace(@str,'⊕','⊕');
set @str = replace(@str,'&zeta;','ζ');
set @str = replace(@str,' ','');
set @str = replace(@str,'&cap;','∩');
set @str = replace(@str,'&hellip;','…');
set @str = replace(@str,'砳','砳');
set @str = replace(@str,'&rho;','ρ');
set @str = replace(@str,'&divide;','÷');
set @str = replace(@str,'&gamma;','γ');
set @str = replace(@str,'≥','≥');
set @str = replace(@str,'·','·');
set @str = replace(@str,'&#39','''');
set @str = replace(@str,'&quot;','"');

set @str=replace(@str,'&forall;','∀');
set @str=replace(@str,'&part;','∂');
set @str=replace(@str,'&empty;','∅');
set @str=replace(@str,'&nabla;','∇');
set @str=replace(@str,'&isin;','∈');
set @str=replace(@str,'&notin;','∉');
set @str=replace(@str,'&ni;','∋');
set @str=replace(@str,'&prod;','∏');
set @str=replace(@str,'&sum;','∑');
set @str=replace(@str,'&minus;','−');
set @str=replace(@str,'&lowast;','∗');
set @str=replace(@str,'&radic;','√');
set @str=replace(@str,'&prop;','∝');
set @str=replace(@str,'&infin;','∞');
set @str=replace(@str,'&ang;','∠');
set @str=replace(@str,'&and;','∧');
set @str=replace(@str,'&or;','∨');
set @str=replace(@str,'&cap;','∩');
set @str=replace(@str,'&cup;','∪');
set @str=replace(@str,'&int;','∫');
set @str=replace(@str,'&there4;','∴');
set @str=replace(@str,'&sim;','∼');
set @str=replace(@str,'&cong;','≅');
set @str=replace(@str,'&asymp;','≈');
set @str=replace(@str,'&ne;','≠');
set @str=replace(@str,'&equiv;','≡');
set @str=replace(@str,'&le;','≤');
set @str=replace(@str,'&ge;','≥');
set @str=replace(@str,'&sub;','⊂');
set @str=replace(@str,'&sup;','⊃');
set @str=replace(@str,'&nsub;','⊄');
set @str=replace(@str,'&sube;','⊆');
set @str=replace(@str,'&supe;','⊇');
set @str=replace(@str,'&oplus;','⊕');
set @str=replace(@str,'&otimes;','⊗');
set @str=replace(@str,'&perp;','⊥');
set @str=replace(@str,'&sdot;','⋅');
set @str=replace(@str,'&Alpha;','Α');
set @str=replace(@str,'&Beta;','Β');
set @str=replace(@str,'&Gamma;','Γ');
set @str=replace(@str,'&Delta;','Δ');
set @str=replace(@str,'&Epsilon;','Ε');
set @str=replace(@str,'&Zeta;','Ζ');
set @str=replace(@str,'&Eta;','Η');
set @str=replace(@str,'&Theta;','Θ');
set @str=replace(@str,'&Iota;','Ι');
set @str=replace(@str,'&Kappa;','Κ');
set @str=replace(@str,'&Lambda;','Λ');
set @str=replace(@str,'&Mu;','Μ');
set @str=replace(@str,'&Nu;','Ν');
set @str=replace(@str,'&Xi;','Ξ');
set @str=replace(@str,'&Omicron;','Ο');
set @str=replace(@str,'&Pi;','Π');
set @str=replace(@str,'&Rho;','Ρ');
set @str=replace(@str,'&Sigma;','Σ');
set @str=replace(@str,'&Tau;','Τ');
set @str=replace(@str,'&Upsilon;','Υ');
set @str=replace(@str,'&Phi;','Φ');
set @str=replace(@str,'&Chi;','Χ');
set @str=replace(@str,'&Psi;','Ψ');
set @str=replace(@str,'&Omega;','Ω');
set @str=replace(@str,'&alpha;','α');
set @str=replace(@str,'&beta;','β');
set @str=replace(@str,'&gamma;','γ');
set @str=replace(@str,'&delta;','δ');
set @str=replace(@str,'&epsilon;','ε');
set @str=replace(@str,'&zeta;','ζ');
set @str=replace(@str,'&eta;','η');
set @str=replace(@str,'&theta;','θ');
set @str=replace(@str,'&iota;','ι');
set @str=replace(@str,'&kappa;','κ');
set @str=replace(@str,'&lambda;','λ');
set @str=replace(@str,'&mu;','μ');
set @str=replace(@str,'&nu;','ν');
set @str=replace(@str,'&xi;','ξ');
set @str=replace(@str,'&omicron;','ο');
set @str=replace(@str,'&pi;','π');
set @str=replace(@str,'&rho;','ρ');
set @str=replace(@str,'&sigmaf;','ς');
set @str=replace(@str,'&sigma;','σ');
set @str=replace(@str,'&tau;','τ');
set @str=replace(@str,'&upsilon;','υ');
set @str=replace(@str,'&phi;','φ');
set @str=replace(@str,'&chi;','χ');
set @str=replace(@str,'&psi;','ψ');
set @str=replace(@str,'&omega;','ω');
set @str=replace(@str,'&thetasym;','ϑ');
set @str=replace(@str,'&upsih;','ϒ');
set @str=replace(@str,'&piv;','ϖ');
set @str=replace(@str,'&OElig;','Œ');
set @str=replace(@str,'&oelig;','œ');
set @str=replace(@str,'&Scaron;','Š');
set @str=replace(@str,'&scaron;','š');
set @str=replace(@str,'&Yuml;','Ÿ');
set @str=replace(@str,'&fnof;','ƒ');
set @str=replace(@str,'&circ;','ˆ');
set @str=replace(@str,'&tilde;','˜');
set @str=replace(@str,'&ensp;','');
set @str=replace(@str,'&emsp;',' ');
set @str=replace(@str,'&thinsp;',' ');
set @str=replace(@str,'&zwnj;','‌');
set @str=replace(@str,'&zwj;','‍');
set @str=replace(@str,'&lrm;','‎');
set @str=replace(@str,'&rlm;','‏');
set @str=replace(@str,'&ndash;','–');
set @str=replace(@str,'&mdash;','—');
set @str=replace(@str,'&lsquo;','‘');
set @str=replace(@str,'&rsquo;','’');
set @str=replace(@str,'&sbquo;','‚');
set @str=replace(@str,'&ldquo;','“');
set @str=replace(@str,'&rdquo;','”');
set @str=replace(@str,'&bdquo;','„');
set @str=replace(@str,'&dagger;','†');
set @str=replace(@str,'&Dagger;','‡');
set @str=replace(@str,'&bull;','•');
set @str=replace(@str,'&hellip;','…');
set @str=replace(@str,'&permil;','‰');
set @str=replace(@str,'&prime;','′');
set @str=replace(@str,'&Prime;','″');
set @str=replace(@str,'&lsaquo;','‹');
set @str=replace(@str,'&rsaquo;','›');
set @str=replace(@str,'&oline;','‾');
set @str=replace(@str,'&euro;','€');
set @str=replace(@str,'&trade;','™');
set @str=replace(@str,'&larr;','←');
set @str=replace(@str,'&uarr;','↑');
set @str=replace(@str,'&rarr;','→');
set @str=replace(@str,'&darr;','↓');
set @str=replace(@str,'&harr;','↔');
set @str=replace(@str,'&crarr;','↵');
set @str=replace(@str,'&lceil;','⌈');
set @str=replace(@str,'&rceil;','⌉');
set @str=replace(@str,'&lfloor;','⌊');
set @str=replace(@str,'&rfloor;','⌋');
set @str=replace(@str,'&loz;','◊');
set @str=replace(@str,'&spades;','♠');
set @str=replace(@str,'&clubs;','♣');
set @str=replace(@str,'&hearts;','♥');
set @str=replace(@str,'&diams;','♦');
set @str=replace(@str,'∀','∀');

set @str=replace(@str,'∂','∂');
set @str=replace(@str,'∃','∃');
set @str=replace(@str,'∅','∅');
set @str=replace(@str,'∇','∇');
set @str=replace(@str,'∈','∈');
set @str=replace(@str,'∉','∉');
set @str=replace(@str,'∋','∋');
set @str=replace(@str,'∏','∏');
set @str=replace(@str,'∑','∑');
set @str=replace(@str,'−','−');
set @str=replace(@str,'∗','∗');
set @str=replace(@str,'√','√');
set @str=replace(@str,'∝','∝');
set @str=replace(@str,'∞','∞');
set @str=replace(@str,'∠','∠');
set @str=replace(@str,'∧','∧');
set @str=replace(@str,'∨','∨');
set @str=replace(@str,'∩','∩');
set @str=replace(@str,'∪','∪');
set @str=replace(@str,'∫','∫');
set @str=replace(@str,'∴','∴');
set @str=replace(@str,'∼','∼');
set @str=replace(@str,'≅','≅');
set @str=replace(@str,'≈','≈');
set @str=replace(@str,'≠','≠');
set @str=replace(@str,'≡','≡');
set @str=replace(@str,'≤','≤');
set @str=replace(@str,'≥','≥');
set @str=replace(@str,'⊂','⊂');
set @str=replace(@str,'⊃','⊃');
set @str=replace(@str,'⊄','⊄');
set @str=replace(@str,'⊆','⊆');
set @str=replace(@str,'⊇','⊇');
set @str=replace(@str,'⊕','⊕');
set @str=replace(@str,'⊗','⊗');
set @str=replace(@str,'⊥','⊥');
set @str=replace(@str,'⋅','⋅');
set @str=replace(@str,'Α','Α');
set @str=replace(@str,'Β','Β');
set @str=replace(@str,'Γ','Γ');
set @str=replace(@str,'Δ','Δ');
set @str=replace(@str,'Ε','Ε');
set @str=replace(@str,'Ζ','Ζ');
set @str=replace(@str,'Η','Η');
set @str=replace(@str,'Θ','Θ');
set @str=replace(@str,'Ι','Ι');
set @str=replace(@str,'Κ','Κ');
set @str=replace(@str,'Λ','Λ');
set @str=replace(@str,'Μ','Μ');
set @str=replace(@str,'Ν','Ν');
set @str=replace(@str,'Ξ','Ξ');
set @str=replace(@str,'Ο','Ο');
set @str=replace(@str,'Π','Π');
set @str=replace(@str,'Ρ','Ρ');
set @str=replace(@str,'Σ','Σ');
set @str=replace(@str,'Τ','Τ');
set @str=replace(@str,'Υ','Υ');
set @str=replace(@str,'Φ','Φ');
set @str=replace(@str,'Χ','Χ');
set @str=replace(@str,'Ψ','Ψ');
set @str=replace(@str,'Ω','Ω');
set @str=replace(@str,'α','α');
set @str=replace(@str,'β','β');
set @str=replace(@str,'γ','γ');
set @str=replace(@str,'δ','δ');
set @str=replace(@str,'ε','ε');
set @str=replace(@str,'ζ','ζ');
set @str=replace(@str,'η','η');
set @str=replace(@str,'θ','θ');
set @str=replace(@str,'ι','ι');
set @str=replace(@str,'κ','κ');
set @str=replace(@str,'Λ','λ');
set @str=replace(@str,'μ','μ');
set @str=replace(@str,'Ν','ν');
set @str=replace(@str,'ξ','ξ');
set @str=replace(@str,'ο','ο');
set @str=replace(@str,'π','π');
set @str=replace(@str,'ρ','ρ');
set @str=replace(@str,'ς','ς');
set @str=replace(@str,'σ','σ');
set @str=replace(@str,'τ','τ');
set @str=replace(@str,'υ','υ');
set @str=replace(@str,'φ','φ');
set @str=replace(@str,'χ','χ');
set @str=replace(@str,'ψ','ψ');
set @str=replace(@str,'ω','ω');
set @str=replace(@str,'ϑ','ϑ');
set @str=replace(@str,'ϒ','ϒ');
set @str=replace(@str,'ϖ','ϖ');
set @str=replace(@str,'Œ','Œ');
set @str=replace(@str,'œ','œ');
set @str=replace(@str,'Š','Š');
set @str=replace(@str,'š','š');
set @str=replace(@str,'Ÿ','Ÿ');
set @str=replace(@str,'ƒ','ƒ');
set @str=replace(@str,'ˆ','ˆ');
set @str=replace(@str,'˜','˜');
set @str=replace(@str,' ','');
set @str=replace(@str,' ','');
set @str=replace(@str,' ',' ');
set @str=replace(@str,'‌','‌');
set @str=replace(@str,'‍','‍');
set @str=replace(@str,'‎','‎');
set @str=replace(@str,'‏','‏');
set @str=replace(@str,'–','–');
set @str=replace(@str,'—','—');
set @str=replace(@str,'‘','‘');
set @str=replace(@str,'’','’');
set @str=replace(@str,'‚','‚');
set @str=replace(@str,'“','“');
set @str=replace(@str,'”','”');
set @str=replace(@str,'„','„');
set @str=replace(@str,'†','†');
set @str=replace(@str,'‡','‡');
set @str=replace(@str,'•','•');
set @str=replace(@str,'…','…');
set @str=replace(@str,'‰','‰');
set @str=replace(@str,'′','′');
set @str=replace(@str,'″','″');
set @str=replace(@str,'‹','‹');
set @str=replace(@str,'›','›');
set @str=replace(@str,'‾','‾');
set @str=replace(@str,'€','€');
set @str=replace(@str,'™','™');
set @str=replace(@str,'←','←');
set @str=replace(@str,'↑','↑');
set @str=replace(@str,'→','→');
set @str=replace(@str,'↓','↓');
set @str=replace(@str,'↔','↔');
set @str=replace(@str,'↵','↵');
set @str=replace(@str,'⌈','⌈');
set @str=replace(@str,'⌉','⌉');
set @str=replace(@str,'⌊','⌊');
set @str=replace(@str,'⌋','⌋');
set @str=replace(@str,'◊','◊');
set @str=replace(@str,'♠','♠');
set @str=replace(@str,'♣','♣');
set @str=replace(@str,'♥','♥');
set @str=replace(@str,'♦','♦');

return @str
end
go