//去掉空格

update T_THIRD_SURVEY_PERSON SET CHECK_DES = trim(replace(CHECK_DES,'   ',','));

//去掉换行符

update T_THIRD_SURVEY_PERSON set CHECK_DES=replace(CHECK_DES,chr(10),',');

//去掉回车

update T_THIRD_SURVEY_PERSON set CHECK_DES=replace(CHECK_DES,chr(13),',');

//去掉tab

update T_THIRD_SURVEY_PERSON set CHECK_DES=replace(CHECK_DES,chr(9),',');

查询语句
直接查询字段中是否包含空格或者tab

select * from table_name where column_name like '% %'

查询字段中是否包含换行符chr(10)、回车chr(13)、tab chr(9)

select * from table_name where instr(column_name,chr(10))>0;