去除字段中的换行符号
--去除字段中的换行符号
select pb.rowid,pb.vdesc,pb.* from tm_part_base pb WHERE instr(pb.vdesc,chr(10))>0;
UPDATE tm_part_base pb SET pb.vdesc=replace(pb.vdesc,chr(13),'') WHERE instr(pb.vdesc,chr(10))>0;
select pb.rowid,pb.vdesc,pb.* from tm_part_base pb WHERE instr(pb.vdesc,chr(10))>0;
UPDATE tm_part_base pb SET pb.vdesc=replace(pb.vdesc,chr(13),'') WHERE instr(pb.vdesc,chr(10))>0;
posted on 2015-12-18 16:19 tongdengquan 阅读(248) 评论(0) 编辑 收藏 举报