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?
