Replace in Sql server

• DexterForALL1986

  SSC Journeyman

  Points: 78

  More actions

  July 18, 2011 at 12:33 am

  #241656

  Hello All,

  I have the following query ..

  I have a Table called Table1 ,having column name

  Body. inside the Column(Body) I have the following

  "Dear Ms/Ms {{T}} ({{K}})

  "

  1> I want to Replace {{T}} ,{{K}} by

  Hello (900090} at runtime

  ie using Select Body

  from Table1

  how to write a replace for that ???:-)

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  July 18, 2011 at 1:57 am

  #1354075

  You can use REPLACE twice...

  SELECT REPLACE(REPLACE(Body, '{{T}}', Col1), '{{K}}', Col2) FROM Table1