using TRANSLATE, REPLACE, DECODE with UPDATE

[Guest_imported]

Wonder if anyone can help?
I'm wanting to perform some simple search/replace operations on data. This is simple enough using TRANSLATE and REPLACE in a SELECT statement ... however ... how do I actually UPDATE the data?
I've tried using a SELECT within the UPDATE, but this doesn't work as the results return more than 1 value.

Example:

select
TRANSLATE(cmp_nam,'.',' '),
TRANSLATE(lst_nam,'.',' ')
from NAMES;

Cheers

 

[sonaliak]

You can try sometthing like this
Update mwebwork
set Work_Description = REPLACE(work_description,'1','phase n')
where Work_ID >500 and work_id <650
GO