How to replace a string in the table in sql server

Question

I have a table named LIST, can anyone please tell me how to replace all the data under the table LIST In sql server

You will need to be a bit more specific in what you are after. What exactly is it you want to do? What have you tried so far? What are you unable to find out? — Miika L.
– Miika L., Commented Apr 5, 2012 at 6:01
Please provide more details, a table can contain many columns, do you want to replace data in one column or all the columns? what string you want to replace and with which string? — Imran Rizvi
– Imran Rizvi, Commented Apr 5, 2012 at 6:01

Imran Rizvi · Accepted Answer · 2012-04-05 06:03:35Z

1

You can replace string in SQL table by following command

Update <tablename> SET <columnname> = '<newstring>'

If you have any condition you can add following line after above line

where <condition>

Condition can be something like

columnname = 'sometext'

answered Apr 5, 2012 at 6:03

Imran Rizvi

7,47813 gold badges63 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JackAce · Accepted Answer · 2012-04-05 06:03:22Z

0

UPDATE
    LIST
SET
    COLUMN1    =    'SOMETHING BESIDES WHAT IS CURRENTLY IN COLUMN1'

answered Apr 5, 2012 at 6:03

JackAce

1,40515 silver badges32 bronze badges