update companyinfo set Province=replace(substring(isnull(regplace,''),1,charindex('-',isnull(regplace,''))),'-',''),City=replace(stuff(regplace,1,charindex('-',regplace),''),case when charindex('-',isnull(regplace,''),charindex('-',isnull(regplace,''))+1)>1 then substring(isnull(regplace,''),charindex('-',isnull(regplace,''),charindex('-',isnull(regplace,''))+1),len(isnull(regplace,''))) else '' end,''),area=replace(isnull(case when charindex('-',isnull(regplace,''),charindex('-',isnull(regplace,''))+1)>1 then substring(isnull(regplace,''),charindex('-',isnull(regplace,''),charindex('-',isnull(regplace,''))+1),len(isnull(regplace,''))) else '' end,''),'-','') where C_ID='00003A3C'