Find Domain Name from Email Address in SQL Server

Hi,

How to find domain name from email Address in SQL table. Example is given below-

Table-

emailaddress

info@techandmate.com

path@tech.com

iim@iim.com

info@techandmate.in

path@tech.org

iim@iim.edu

info@techandmate.brazil

path@tech.org

iim@iim.edu

Output

DOMAIN

techandmate

tech

iim

techandmate

tech

iim

techandmate

tech

iim

Thanks,

  Devbrat Tripathi

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any