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 |
| < | < | < | less-than |
| > | > | > | greater-than |