Changing the data in a Column

• Lavanyasri

  SSCarpal Tunnel

  Points: 4907

  More actions

  February 22, 2012 at 4:24 am

  #257252

  HI All,

  I want to update the data in a particular column[column data type is String ] .

  Ex: The data in the column is 'www.sql.com' , Now i want to change like this

  'qa.sql.com' . The coulmn contains almost 500 records of data. I want to change all the records of that particular column .

  Please help on this is issue. Its very urgent .

  Thanks,

  Lavanya

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  February 22, 2012 at 4:26 am

  #1450174

  sheesh

  update table

  set columnname = value

  where columname = filter

  please lookup BOL for UPDATE.

  You could use the replace function too or simply update nilly willy.

  Jayanth Kurup[/url]

• Lavanyasri

  SSCarpal Tunnel

  Points: 4907

  More actions

  February 22, 2012 at 5:01 am

  #1450180

  Thanks ,

  I got the solution for my problem .

  UPDATE tablename

  SET columnname = replace(columnname,'olddata', 'newdata')

  WHERE columnname LIKE 'abc%';

  Thanks

  Lavanya