I've got a column of varchar data that's populated with standard sql statements. so the table might look like this:
SELECT X FROM Y where [abc]='def' and [ghi]='asdf'
INSERT INTO J (abc,def) Values (1,'aced')
I want to update the Statement column so that all values within single quotes are replaced with empty string. so in the example above the result would be:
SELECT X FROM Y where [abc]='' and [ghi]=''
INSERT INTO J (abc,def) Values (1,'')
I don't know a prior how many single quotes there are, but I do know that they will always be balanced.