Replace -- fails to "WRITE" changes to DB

• finance_teacher

  Right there with Babe

  Points: 745

  More actions

  February 1, 2005 at 8:56 pm

  #74854

  How can I change the following so

  REPLACE "writes" changes to the database

  instead of the current "display new results,

  don't write changes" like it currently does ?

  SELECT REPLACE(NAME,

  SUBSTRING(NAME, CHARINDEX('2004',

  NAME), 4), '2005')

  FROM         dbo.[PRODUCT]

  WHERE     (NAME LIKE '%2004%')

• Anoop P.

  SSCommitted

  Points: 1632

  More actions

  February 1, 2005 at 9:56 pm

  #540081

  Use an update statement.

  update product

  set name = REPLACE(NAME, '2004', '2005')

  where  (NAME LIKE '%2004%')

  In your query,

  SUBSTRING(NAME, CHARINDEX('2004',

  NAME), 4)

  would ultimately return you '2004' itself. So I have directly used '2004' in the update statement.