how to replace text in a particular column on a table in sqlserver

Question

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?

codingbadger · Accepted Answer · 2011-03-01 08:09:32Z

4

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.

edited Mar 1, 2011 at 8:09

answered Mar 1, 2011 at 8:01

codingbadger

44.3k13 gold badges99 silver badges113 bronze badges

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

Comments

The Scrum Meister · Accepted Answer · 2011-03-01 08:00:16Z

2

Use the REPLACE function with a UPDATE statement:

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

answered Mar 1, 2011 at 8:00

The Scrum Meister

30.2k8 gold badges69 silver badges65 bronze badges

Collectives™ on Stack Overflow

how to replace text in a particular column on a table in sqlserver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related