UPDATE 表名 SET 字段名 = "字段值"+right(字段名,len(字段名)-要替换的字段的长度)
WHERE 字段名 like "原字段值*";
例:
UPDATE MutiFile SET path = "D:/目录/"+right(path,len(path)-10)
WHERE path like "//My/d/目录/*";
注意:汉字算一个字符.
WHERE 字段名 like "原字段值*";
例:
UPDATE MutiFile SET path = "D:/目录/"+right(path,len(path)-10)
WHERE path like "//My/d/目录/*";
注意:汉字算一个字符.