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 - 2002-02-10 : 19:36:15
|
| Travis writes "I'm trying to permanently replace a certain word in all records of a table (SQL SERV 2000). I can of course use the REPLACE syntax; however, this only modifies the output. I think I also could change entire strings, but not text within a string. For example, I need to replace all instances of "http://edmssappt1" with "http://edmssappp1" that may be in a 16,000 character string.The workaround I've used so far is export the table to Access and use the find/replace function. Doing this, however, is slow and makes me very uneasy.Any help?" |
|
|
|
|
|
Replacing (permanently) text in a string