How to select @ from mail Id in sql server E.g abc@gmail.com O/p : @

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

Hi, please check this link: https://stackoverflow.com/questions/2628138/how-to-select-domain-name-from-email-address

Hello Check these Links https://www.tutorialgateway.org/sql-extract-domain-from-email/ https://www.sqlservercentral.com/forums/topic/sql-statement-to-get-before-from-email-address https://blog.sqlauthority.com/2011/06/18/sql-server-selecting-domain-from-email-address/