What is the proper syntax for replacing characters?
My replace statement:
Select replace(note,’old’,’new’) from history
So I am trying to update instances of 'old' to 'new' in the note column of the history table.
The result: The updated text is displayed as I would it expect but the change is not committed so the actual update doesn't happen.