/*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),
'')
转载于:https://www.cnblogs.com/siyunianhua/p/3359217.html
