Jump to content

TULMER

Members
  • Content count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About TULMER

  • Rank
    Newbie
  1. updatetext

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

    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?
×