MS SQL update html

String to update html text in SQL database

DECLARE @FIND as NVarchar(MAX)
DECLARE @REPLACE as NVarchar(MAX)
SET @FIND = ‘OLD Value’
SET @REPLACE = ‘NEW Value’
UPDATE [Your Table Name]
SET [Column name] = cast(replace(cast([Column Name] as NVarchar(max)),@FIND,@REPLACE) as Ntext)

 

Substitute text in OLD and NEW values as presented below, instead of ” placeĀ " and so on all below.

" " quotation mark
' ' apostrophe
& & & ampersand
< &#60; &lt; less-than
> &#62; &gt; greater-than