how to get email-id from string in sql server?
===

    DECLARE @str as varchar(500) = '</FONT><FONT SIZE=2 FACE="Arial">atul.kale@bca.net</FONT><FONT SIZE=2 FACE="Arial">'
    SELECT substring(@str,patindex('%">%',@str),patindex('%</FONT>%',@str))

I'm trying to get email id from `@str` string.

output should be.
----------------------

    atul.kale@bca.net

I'm not getting how should i deal with in substring in sql-server?
