Assuming you're not using a Distributed file, try: UPDATE VOC SET F2 = '/newpathname/' || @ID WHERE F2 = '/oldpathname/' || @ID; UPDATE VOC SET F3 = '/newpathname/D_' || @ID WHERE F3 = '/oldpathname/D_' || @ID;
(The || is SQL's concatenation operator.) ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/