MSSQL Get Domain From Email Address

SELECT DISTINCT RIGHT(Email, LEN(Email) - CHARINDEX('@', email)) Domain
FROM contacts

SELECT RIGHT(Email, LEN(Email) - CHARINDEX('@', email)) Domain,
	COUNT(Email) EmailCount
FROM contacts
WHERE LEN(Email) > 0
GROUP BY RIGHT(Email, LEN(Email) - CHARINDEX('@', email))
ORDER BY EmailCount DESC,
	Domain

Reference: https://blog.sqlauthority.com/2011/06/18/sql-server-selecting-domain-from-email-address/

All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.

Related