travisbrown
Technical User
- Dec 31, 2001
- 1,016
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 " with " 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?
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?