<div>
<i>&gt;&gt;Will this statement work?&lt;&lt;</i><br />
Run it as a select statement first then see (you might want to limit the number of rows).<br />
select replace(email,'@blue.com',<wbr />'@white.co<wbr />m') from user WHERE email LIKE '%@blue.com';
</div>


>>Will this statement work?<<
Run it as a select statement first then see (you might want to limit the number of rows).
select replace(email,'@blue.com','@white.com') from user WHERE email LIKE '%@blue.com';

<div>
<div class="content wysiwyg-content">
Hello Experts - <br />
<br />
I need an SQL update statement to execute against a column in my 'user' table called 'email'. Right now, it contains similar emails for all of my users: mary.jones@blue.com, brian.hall@blue.com etc. The company (email domain) has just changed names to something entirely different, so they all need to now be mary.jones@white.com, brian.hall@white.com etc. The change is the same for everyone, two entirely unique company names, so, from @blue.com to @white.com.<br />
<br />
Will this statement work? I'm on SQL 2008.<br />
<br />
UPDATE user SET email = replace(email,'@blue.com',<wbr />'@white.co<wbr />m') WHERE email LIKE '%@blue.com';<br />
<br />
I'm going to test and backup, but I just want to make sure the above function does what I think it's going to do. Any suggestions are helpful.<br />
<br />
Thank you,<br />
Marcos
</div>
</div>


Hello Experts - 

I need an SQL update statement to execute against a column in my 'user' table called 'email'. Right now, it contains similar emails for all of my users: mary.jones@blue.com, brian.hall@blue.com etc. The company (email domain) has just changed names to something entirely different, so they all need to now be mary.jones@white.com, brian.hall@white.com etc. The change is the same for everyone, two entirely unique company names, so, from @blue.com to @white.com.

Will this statement work? I'm on SQL 2008.

UPDATE user SET email = replace(email,'@blue.com','@white.com') WHERE email LIKE '%@blue.com';

I'm going to test and backup, but I just want to make sure the above function does what I think it's going to do. Any suggestions are helpful.

Thank you,
Marcos

SQL Statement to Update Email Domain

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.