How to replace text in a specific column of a table in sqlserver

Question

I have an Employee table with a Description column. In the description column I have text <br />. Now I need to replace this text with text <br>.

Is there any way to change the value in the column itself?

Answer 1

Update Employee
Set Description = Replace(Description , '<br />','<br>')
Where IDColumn = RecordIdValue

You can omit the sentence whereif you want to update ALL rows in the table.

Answer 2

Use REPLACEwith UPDATE:

UPDATE EMployee
SET Description = REPLACE(Description, 'find this text', 'replacement')