Thread: update part of a column record

update part of a column record

From

Marc Fromm

Date:

08 September 2009, 16:52:13

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

Re: update part of a column record

From

Aras Angelo

Date:

08 September 2009, 16:54:47

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@wwu.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