Search & Replace in TEXT or NTEXT Fields

• labware

  SSC Rookie

  Points: 42

  More actions

  March 13, 2003 at 8:48 am

  #80469

  Does anyone have any routines to Search & Replace text in a TEXT or NTEXT field? The REPLACE SQL statement doesn't work on these field types

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 14, 2003 at 6:25 am

  #451097

  Have a look at UPDATETEXT in Books Online.

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/