--去除换行chr(10)

update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(10),'');

--去掉回车chr(13)

update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(13),'');

--去掉空格chr(32)

update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(32),'');

--去掉两边空白trim()

update zhzl_address t set t.add_administration_num=trim(t.add_administration_num);

--特殊符号ascii定义

--制表符 chr(9)

--换行符 chr(10)

--回车符 chr(13)
附上ASCII码: