IT WORKED!!

update tel_tldiremp

SET email_address = Replace(email_address, 'emailaddress.net', 'newemailaddress.net')

IT WORKED!!!

THANK YOU!!  IT WORKED!

SET email_address = Replace(email_address, 'emailaddress.net', 'newemailaddress.net')

Gives this errorLine 1: Incorrect syntax near '='.

SELECT email_address , Replace(email_address, '@emailaddress.net', '@newemailaddress.net')

FROM dbo.TableName

This delivers all email addresses not just the email addresses ending in emailaddress.net.  20,000 emails vs 2,000.  I messed around with it a bit...

Thank you for your reply.  Further investigation of my configuration has left me with a bit of an empty feeling.  This is what I have - one physical drive, RAID 5,...