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
updating a varchar
Posted - 10/09/2012 : 17:05:05
