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 '%:%' ;
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 '%:%' ;