FN-FORUM: T-SQL Question

date posted 8th March 2006 15:35

Well it's probably a general SQL question really.

I have a very small table with two simple rows, an id and a sentence of
text.

I have a small problem in that the text has been added online (ages ago) and
some of the text has " instead of " (I assume output escaping wasn't
considered!)

So my question is... How can I create a query to do a batch update of all
the records that contain these elements?

The query I have so far is just a simple update query that looks like this:

UPDATE table
SET text = '"text inside quote marks..."'
WHERE text like '%"%'

However, I've found out there other tables affected by this problem and it
will take me an awwwwwful long time to update them all with writing out
single UPDATE queries.

Oh and the table has no relationship (thank the lord!!!)

TIA

Stephen.