SET NOCOUNT ON --关闭回显 REPLACE (REPLACE (REPLACE (FieldName,CHAR(13)+CHAR(10),''),'"',''),',','') --去除回车、空白、逗号