UPDATE table SET column=REPLACE(column,'@
cc.edu','@
somethingelse.com');
change "column" to field name respectively.
On Tue, Sep 8, 2009 at 10:46 AM, Marc Fromm
<Marc.Fromm@xxxxxxx> wrote:
I have a column that contains user email addresses. I need
to update all email address in the column that end with @cc.edu to @ss.edu and
retain the information (the user name) that exists before the @ symbol. Is
there an update query that can edit part of a column record?
Marc
