All,<BR>Need some help with the following situation. In my DB, I have a column titled RID. RID contains a unique number for each field in the DB. I also have a column called Hi-res path. The hi-res path contains the path for each record in the following format: \SERVER1folderfile.eps. Due to space issues, I had to move the hi-res directory to another server, so now I need to update all of the records to read: \SERVER2folderfile.eps. Is there an easy way to do this with a SQL stored procedure. I was looking into the Replace() method within MSSQL and it seemed like a good fix, but I couldn't quite get the syntax right for an entire stored procedure. Any help would be appreciated.