--去除字段中的换行符号
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;