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/

Answers

How to select @ from mail Id in sql server

krunal pande

964

How to select @ from mail Id in sql server E.g [email protected] O/p : @

Answers (3)

Next Recommended Forum

which good select from view or SP or normal select?

How can I return multiple rows as a single row in sql server

Forum Statistics

Please welcome our newest member zc y.
3,089,307 users have contributed to 147,411 threads and 483,542
In the past 24 hours, we have 4 new threads, 11 new posts, and 142 new users.
In last week, the most popular thread is 'Differences between .NET Framework, .NET Core, and .NET 5+ versions'.

Upcoming Events

View all

Auto-Archive Client Documents for Compliance: Automate Your Business Processes - Ep.6
Vibe Coding Bootcamp
Software Architecture Conference - 2025