Reputation: 7777
I have an table Employee, with a Description column. In the description column I have the text
<br />
. Now I need to replace this text with the text <br>
.
Is there any way that i could modify the value in the column itself?
Upvotes: 3
Views: 3362
Reputation: 44032
Update Employee
Set Description = Replace(Description , '<br />','<br>')
Where IDColumn = RecordIdValue
You can omit the where
clause if you want to update ALL rows in the table.
Upvotes: 4
Reputation: 30131
Use the REPLACE
function with a UPDATE
statement:
UPDATE EMployee
SET Description = REPLACE(Description, 'find this text', 'replacement')
Upvotes: 2