Informix 数据库字段replace

snowdymy

update informix.t_nameinfo set  code=replace(code,'；','*') where code like '%；%' ;
Select * from informix.t_nameinfo  where code like '%；%' ;


update informix.t_nameinfo set  code=replace(code,'：','-') where code like '%：%' ;
Select * from informix.t_nameinfo  where code like '%：%' ;


update informix.t_nameinfo set  standardname=replace(standardname,'；','*') where standardname like '%；%' ;
Select * from informix.t_nameinfo  where standardname like '%；%' ;


update informix.t_nameinfo set  standardname=replace(standardname,'：','-') where standardname like '%：%' ;
Select * from informix.t_nameinfo  where standardname like '%：%' ;