didn't work -- only replaces complete email address with the field name:
UPDATE cicntp
SET cnt_email = REPLACE ('cnt_email', 'oldname.com', 'newcompanyname.com')
WHERE (cnt_email LIKE '%@oldname.com')
___ results are email address goes to "cnt_email" and nothing more.