--替换回车符 REPLACE(exp, CHAR(13), '') --替换换行符 REPLACE(exp, CHAR(10), '') --水平制表符 REPLACE(exp, CHAR(9), '') 转载于:https://www.cnblogs.com/liyangabc/p/10237651.html