SQL Server search and replace text in table

To do a search and replace in an SQL table use the following code:

UPDATE <TABLE NAME>

SET <COLUMN NAME> = CAST(REPLACE(CAST(<COLUMN NAME> as varchar(MAX)), '<TEXT TO FIND>', '<TEXT TO REPLACE>') as text)

WHERE

PATINDEX('%<TEXT TO FIND>%', <COLUMN NAME>) > 0