SQL Tips #13 - Finding the Domain from an Email Address

When you have a table of email addresses, it's sometimes useful to see the distinct domains they belong to.

The Query

SELECT distinct RIGHT(email, LEN(email) - CHARINDEX('@', email)) as domain 
FROM dbo.tblUsers
WHERE LEN(email) > 0

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags