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(dot)Fromm(at)wwu(dot)edu> 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
>
>
>