Update query replace string - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Update query replace string

Author

Topic

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2008-09-24 : 12:27:26

In the "filepath" field i have the following "D:\EUploadFileScan\DUS\RM\2026.pdf"
for almost 2000 records in the table.

Now want to replace just the first portion of the path for all the records in the table
from "D:\EUploadFileScan\" to "D:\ProjectImages\"

update Table_Documents set filepath=to replace from "D:\EUploadFileScan\" to "D:\ProjectImages\"

Thank you very much for the helpful information.

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2008-09-24 : 12:51:22

UPDATE yourTable
SET yourColumn =
REPLACE (yourColumn,'D:\EUploadFileScan\','D:\ProjectImages\')

Jim

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources