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 |
|
trademind
Starting Member
2 Posts |
 Posted - 2008-07-08 : 21:57:58
|
| Hi All, i am having difficulties to find a function replace some text into and NTEXT field of a SQLServer database. I need to remove a string that always come at the end of each records and is a fixed lenght, about 20 char. maybe can be done in 2 ways, a search and replace or a trm of the final part of the string. Anyone can suggest a piece of code to run?Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-08 : 23:14:25
|
| Take look at updatetext in books online. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-09 : 00:51:55
|
| look here for example code:-http://www.sqlservercentral.com/articles/Miscellaneous/handlingthetextdatatype/985/ |
|
|
|
|
|
|
Ntext Replace