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 ")
发布时间: 2012-03-23 12:06:21 作者: rapoo
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 ")