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 |
|
SQLapprentice
Starting Member
29 Posts |
 Posted - 2012-01-19 : 18:50:32
|
| Hi all,I have a text kept in a database, which later I will load into a jsp. There are some phrases in this text that I would like to tag.For example, finding a phrase in the text, and replace it with <map this this and that...> phrase </map>. So the text would be exactly the same except for having some tagged phrases that will be useful for the user later.Can someone give me a help on this?Thanks in advance,Kind Regards. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-19 : 19:15:52
|
| [code]UPDATE yourTable SET yourColumn = REPLACE(yourColumn,'phrase', '<map this this and that...>phrase</map>');[/code] |
 |
|
|
SQLapprentice
Starting Member
29 Posts |
Posted - 2012-01-19 : 19:42:39
|
| Thank you! Regards |
|
|
|
|
|
|
FIND AND REPLACE TEXT SQL