Updating Text Data - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Updating Text Data

Author

Topic

Binu
Starting Member

1 Post

Posted - 2007-07-12 : 11:39:40

I have table that has a text column.That contains a word virus. I want to set '..' in place of virus. single column containt more than 8kb data pls help me
Binu

nr
SQLTeam MVY

12543 Posts

Posted - 2007-07-12 : 11:43:48

see
http://www.nigelrivett.net/SQLTsql/ReplaceText2.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-12 : 12:02:02

moved from article discussion

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources