Hi all I need to replace all the values in a table where a certain key is "ABCD.%" to "WXYZ.%"... I thought 'replace' would be able to do that. I'm not sure of the syntax though. Can somebody please help or suggest another alternative. i tried : Code (Text): select replace ((select "Key" from TABLE where "Key" like 'ABCD.%','ABCD','WXYZ') from dual only to get error. Thanks in advance.