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:

<div style="this;is;ok;">This is okay; but <img src="this;"/> is not</div>

Can this be done?

Best Answer

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.