代码如下:/*LYXXB(陵园信息表)lymc(甲方),dz(通信地址),dh(联系电话)*/SELECT lymc,dz,dh FROM lyxxb/*去掉回车(\b)*/update lyxxb set dz=replace(dz,chr(13),”)/*去掉换行(\n)*/update lyxxb set dz=replace(dz,chr(10),”)/*去掉回车(\b)*/update lyxxb set dh=replace(dh,chr(13),”)/*去掉换行(\n)*/update lyxxb set dh=replace(dh,chr(10),”)/*YWDJB(业务登记表
