On Sun, December 10, 2006 6:40 pm, George Nassas wrote: > update videometadata > set filename = insert(filename, 1, length('/old/path'), '/new/path') > where filename like '/old/path%'; Yes, use that it's far superior. I didn't know about the insert() function, is that a MySQL-specific construct? Jesse.