Post reply

Changing the data in a Column

  • 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

  • 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]

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply