Hello everyone..

I need help here in Writing this update statement on a Column 'emailaddr_'. One of our Clients have changed their emai Domain from say abc.com to xyz.com. I need to update all the Rows that abc.com to xyz.com.


For eg.

Source Table Column
--------------------
[email protected]
[email protected]


target Table
------------
[email protected]
[email protected]


I have like 950 Records whose email domain needs to be changed.

Can anyone help me here in Writing a sq ?..

Any help is appreciated

Ron