devxlogo

Changing the Text Value of a Populated Field

Changing the Text Value of a Populated Field

Question:
How do I correct a spelling error in a table? I am at a loss as to where to start.

Answer:
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.

devx-admin

Share the Post: