Jump to content


  • Posts

  • Joined

  • Last visited

Posts posted by TULMER

  1. 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.

  2. I need to update over 400 email address in a table in the database.  I need to keep the first half of the email address and change everything after the '@' symbol.

    Example:  FROM:  john.doe@oldname.com  -- TO:  john.don@newcompanyname.com

    Is there any easy way?

  • Create New...