I have the following issue that I am looking to solve via SQL.
A varchar contains the following: Option 1  Option 2  Option 3 [x] <variable text>
I would like to be able to change the lines with "Option" in them without knowing fully what the line contains. In this case I would not know that Option 1 & 2 where unchecked and Option 3 was. This means using a simple replace would not work. In pseudo code:
update Table set VarChar replace 'Option 1 *' with 'Option 1 [x] replace 'Option 2 *' with 'Option 2  replace 'Option 3 *' with 'Option 3  keep rest of text unchanged