How do I correct a spelling error in a table? I am at a loss as to where to start.
Hoping for the best, I'd say that what you need to do is something like this:
UPDATE MyTable.MyField SET MyTable.MyField = to NEWVALUE where MyTable.MyField = OLDVALUE
On the other hand, if things are more complex in your situation, you will have to use READTEXT and WRITETEXT to extract the part of the field that needs fixing and then put it back.