-- 多语言扫描分号有问题,替换成空格
-- 中文分号替换
update t_fa_depremethod_l set fformula = replace(fformula,'；',' '),fformuladyn = replace(fformuladyn,'；',' ') where 
FPKID in ('100zh_CN','100zh_TW','200zh_CN','200zh_TW','300zh_CN','300zh_TW','400zh_CN','400zh_TW') and FLOCALEID in ('zh_CN','zh_TW');

-- 英文分号替换
update t_fa_depremethod_l set fformula = replace(fformula,';',' '),fformuladyn = replace(fformuladyn,';',' ') where 
FPKID in ('100zh_CN','100zh_TW','200zh_CN','200zh_TW','300zh_CN','300zh_TW','400zh_CN','400zh_TW') and FLOCALEID in ('zh_CN','zh_TW');