philwes83170
MIS
I need to make a mass change to a field that contains an email address. Values are standard format (joe@company.com, sally@company.com, etc). I need to change all the endings to @newcompany.com. The table holds about 500 records so I would like to write an update statement to do this.
Not being a very proficient SQL User though I'm not sure how to just replace the company.com part. Help....
Not being a very proficient SQL User though I'm not sure how to just replace the company.com part. Help....