Replace function

• Johnson330

  Old Hand

  Points: 345

  More actions

  June 21, 2022 at 2:59 pm

  #4052786

  Hi,

  Which is the best\elegant way to update a string in nvarchar(MAX) column?

  The record contains a string similar to this:

  'The dog cat sat on the mat'

  I just want to replace the above to this:

  'The cat sat on the mat'

   

  Is this is the best way:

   

  
  UPDATE myTable SET
  ColumnB=REPLACE(ColumnB,'dog cat','cat' )
  WHERE ColumnC='SentenceOne'

  Thank you

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  June 21, 2022 at 7:47 pm

  #4052913

  That works.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/