I am trying to update part of a string for dozens of entries in a table with CN instead of NC and it doesn't appear to be working. e.g. Trying to change entry NC - 2010 - 000018 so it now reads CN - 2010 - 000018
UPDATE TABLE SET column = replace(column, 'NC%', 'CN%') WHERE column LIKE 'NC%';
Is this possible? Am I missing some coding somewhere? I'm using SQL developer.