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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-26 : 08:14:59
|
| Keith writes "Hello -I am running MS SQL 7.0, sp3. I am running an application called iManage which creates it's own table structure in a SQL database. There is one large table named Docmaster. Within Docmaster, there is a column named Docloc. Basically this column lists the file location of certain files stored in a NT file share. Each row within this table is one of these files.Okay, here is what I need help with. Roughly there are about 5000 rows in the Docmaster table. Every row in the Docloc column should look something like this...DOCUMENTS:\IMANAGE\ADMINIST\0\1\1.1DOCUMENTS:\IMANAGE\ADMINIST\0\1\2.1DOCUMENTS:\IMANAGE\ADMINIST\0\1\2.2After a bad import, roughly 500 rows in this column look something like this...D:\WORK_VAULT\IMANAGE\ADMINIST\0\1\3.1D:\WORK_VAULT\IMANAGE\ADMINIST\0\1\4.1D:\WORK_VAULT\IMANAGE\ADMINIST\0\1\4.2Is there a way to run an update statement on a certain amount of rows to change part of a row? For instance, I would like to run an update statement to change the D:\WORK_VAULT to DOCUMENTS:\.I hope this makes sense. I am not quite sure how to do this. Maybe the user of a wildcard or something.Any help would be greatly appreciated.Thank you!Keith" |
|
|
|
|
|
SQL update statement