Help with updating an entire table with one query
Posted on 2014-12-17
I have a table where some old code was being used to store quotes, and I have fixed the code so it stores data correctly. But, now I need to clean up the table. Basically, I need to search the entire table, all fields, and replace ~~ with " wherever it is found.
I can do this one at a time like Update Table Set Field = replace(Field, '~~', '"'), but I dont' want to do this 100 times with different field names.
Any ideas on how to do it at once?