原来有这么多的特殊字符sql里面

＜|＞|｝|｛|…|｀|＆|\\|/|‐|\^|.|●|@|【|】|〉|〈|♀|#|:|$|ユ|＊|☆|※|·|—|-|,|。|\.|\[|\]|<|>|，|/|、|—|\*| |~|·|※|\{|\}|:|\(|\)|《|》|“|’|''|"|_|&|☆|＊|=|!|★|＠
select dbo.regexReplace(u_account,'[ |=|の|-|〔|〕|：|［|．| |／|`|?|”|！|□|＿|］|＂|．|＾|♂|+|～|‘]','',1,1) from userinfo WHERE (U_Account like '%[^a-zA-Z0-9]%')