data type text invalid for replace function

• manojkanoi

  SSCrazy

  Points: 2292

  More actions

  May 13, 2003 at 5:55 pm

  #101478

  I am trying to replace part of a text in a table with ntext data type.

  When I run the following sql query

  update products set info = replace(info, 'target="main"', '')

  where info like '%target="main"%'

  I get the error "Argument data type text is invalid for argument 1 of replace function."

  What would the best way for me to replace this text?

  Thanks.

• winash

  SSChampion

  Points: 11446

  More actions

  May 13, 2003 at 7:31 pm

  #457053

  For text,ntext or image columns you will have to use UPDATETEXT...

  the following article explains how to use UPDATETEXT

  http://www.sqlservercentral.com/columnists/rmarda/handlingthetextdatatype.asp