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-04-08 : 12:02:05
|
Wayne writes "I have a large SQL 7.0 table with a column of datatype 'text'.
My question is this: How do I search for a word within a record, and replace it with another word without affecting the other text within the record??
Example:
A quick brown fox
becomes:
A quick brown cow
So my query searches for the word 'fox' and replaces it with the word 'cow'
If there is a quick and easy way to do this in T-Sql, I'd love to hear about it.
Thanks, and congrats on a great website." |
|
|
|
|
|
Inline Search and Replace