DECODE statement

[kmesser]

UPDATE TABLEX SET COLUMN_NAME = REPLACE(COLUMN_NAME,'EDGEWATER','DUCK') WHERE COLUMN_NAME = 'EDGEWATER POND';