T-SQL-更新字段[已关闭]

我正在使用SQL Server 2008 R2。

如何更新字段,如下所示:

""AUGUSTO NETO"" <augusto@uol.com>
""ANTONIO FAUSTINO"" <faustino@bol.com>
""ANDRE FORTINO"" <fortino@gmail.com>
""ADAUTO NETO"" <adauto@hotmail.com>

到

augusto@uol.com
faustino@bol.com
fortino@gmail.com
adauto@hotmail.com

我已经知道如何删除一些字符:

update myTable set [E-mail]=REPLACE([E-MAIL],'""','') WHERE [E-MAIL] LIKE '%@%'
update myTable set [E-mail]=REPLACE([E-MAIL],'<','') WHERE [E-MAIL] LIKE '%@%'
update myTable set [E-mail]=REPLACE([E-MAIL],'>','') WHERE [E-MAIL] LIKE '%@%'

有人知道我该怎么解决吗?

提前谢谢。