SQL, How to use a replace function in an update statement.

By Charles McDowell

Comptia Certified Linux Networking Professional.

Cisco Certified Networking Technician.

Microsoft Technology Associate Database Administration

View fullsize

““Failure is an option here. If things are not failing, you are not innovating ”
”

— Elon Musk

An example of using and update statement to replace a value with another value on a table.

update table
set Field = replace(convert(varchar(max), Field), 'Find', 'Replace')
where clause