Remove all instances of a character from a column within tag I don't know much about writing SQL and a client of mine has an erroneous semicolon appearing in his database that he'd like removed. It's in 1 specific column, but it should only be removed if it is within an  tag. For example:

MyColumn
--------
&lt;div style="this;is;ok;"&gt;This is okay; but &lt;img src="this;"/&gt; is not&lt;/div&gt;


Can this be done?
Short answer - yes, it could be done

Correct and full answer depends from other information

For single (or predefined number of tags) - You can prepare UPDATE SQL for XML nodes and use REPLACE T-SQL function for updated parameters

The is will work if You need remove all ";" from TAG, if logic more complicated - solution will not work.