Mass update of TEXT fields

• David.Poole

  SSC Guru

  Points: 76191

  More actions

  October 21, 2003 at 1:45 am

  #101724

  I want to write a mass update of all records in a table updating the contents of a text field so that any instances of single-quotes are replaced with an HTML entity.

  Is there a simple way of doing this or do I have to work through the entire table, record by record using TEXTPTR and WRITETEXT?

  LinkedIn Profile

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 21, 2003 at 1:51 am

  #478900

  Hi David,

  not long ago I asked this question the other way round

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16982&FORUM_ID=8&CAT_ID=1&Topic_Title=REPLACE+on+text+column&Forum_Title=T%2DSQL>

  Frank

  http://www.insidesql.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]