Query to remove """" (incomplete notes) from old procs

drtech · Post by **drtech** » Mon Feb 18, 2008 10:18 am

Is there a query i could run to remove the """" from old proc notes that have built up? Some of our staff have been forgetting to delete these when typing in notes and now there are lots of extra ones that are showing up on the report I would like to just erase.

Post by **jordansparks** » Mon Feb 18, 2008 11:24 am

Queries with quotes in them are always tricky to put together. On a TEST database, I would try some variants of the following query:
UPDATE procnote SET ProcCodeNote=REPLACE(ProcCodeNote, '""', '');
or
UPDATE procnote SET ProcCodeNote=REPLACE(ProcCodeNote, '\"\"', '');
or something like that. Please note that I have not tested the above queries. Running them in Navicat will be more informative since it will tell you how many rows were altered.