//去除换行
update test t set t.mer_name=replace(t.mer_name,chr(13),'');
//去除回车
update test t set t.mer_name=replace(t.mer_name,chr(10),'');
//去除换行
update test t set t.mer_name=replace(t.mer_name,chr(13),'');
//去除回车
update test t set t.mer_name=replace(t.mer_name,chr(10),'');