Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
LKMA
LKMA
3 Posts
ACCEPTED ANSWER

Pinned topic 'Replace' syntax

‏2012-03-07T07:52:27Z |
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.