Partial Update

• nagarjuna02

  SSC Journeyman

  Points: 77

  More actions

  July 23, 2010 at 8:37 am

  #227124

  I have a table "tblGoals"

  with a column "FocusMembers"

  Data would be like this

  "ram,kin,jai."

  "meenu,sona,kiran."

  "rama,raja."

  Will I be able to update a single name from the entire field.

  Eg- Changing "meenu,sona,kiran." to "Raman,sona,kiran."

  if I get just "meenu" and "Raman" as inputs.

  Thanks

  Nag.

• jeff.mason

  SSCrazy Eights

  Points: 9635

  More actions

  July 23, 2010 at 8:46 am

  #1197553

  Check BOL for the REPLACE string function. This is what you want.

• Mike01

  SSChampion

  Points: 11420

  More actions

  July 23, 2010 at 10:24 am

  #1197614

  sounds like homework. If it isn't then can you post DDL and what you have tried so far?

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/