评：


去除换行
update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(10),'');

去掉回车
update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(13),'');

去掉空格
update zhzl_address t set t.add_administration_num=trim(t.add_administration_num);