CODEWITHSUNDEEP
sqlsql-server
Richu
Richu

Reputation: 1

How to replace a string in the table in sql server

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

Upvotes: 0

Views: 132

Answers (2)

Imran Rizvi
Imran Rizvi

Reputation: 7438

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'

Upvotes: 1

JackAce
JackAce

Reputation: 1405

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

Upvotes: 0

Related Questions