删除字段指定数据
str=随机,随机,随机,随机,随机
例
str=3434,ijljo,34343,54545,jioj
如果我只想删除34343怎么能实现呢?
变成str=3434,ijljo,54545,jioj
每一组都用“,”隔开,当然字段不是固定不变的
[解决办法]
先select出来,replace替换掉以后再update进去
[解决办法]
str = "3434,ijljo,34343,54545,jioj"
n = "34343"
str = Replace("," & str & ",", "," & n & ",", ",")
str = Left(str, Len(str)-1)
str = Right(str, Len(str)-1)
[解决办法]