REPLACE有关问题

REPLACE问题REPLACE(字段1, 0 , 原来0 )字段1还有值1,如何同时替换[解决办法]REPLACE(字段1, 原来0 ,

REPLACE问题
REPLACE(字段1, "0 ", "原来0 ")  

字段1还有值1,如何同时替换

[解决办法]
REPLACE(字段1, '原来0 ', '0 ')
[解决办法]
不能同时替换
REPLACE(字段1, "0 ", "原来0 ")
REPLACE(字段1, "1 ", "原来1 ")
[解决办法]
REPLACE(REPLACE(字段1, "0 ", "原来0 "), "1 ", "原来1 ")