读书人

REPLACE有关问题

发布时间: 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 ")

读书人网 >.NET

热点推荐