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

917

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

Leaderboard

View all

Mahesh Chand

Vijay Pratap Singh

George

View all

Yesterday's leader

Mahesh Chand

Startup Advisor, Speaker, Author, Architecture, Innovation

Philadelphia (USA)

241.5m

271k

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

289.4k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.4k

58.5k

Upcoming events

View all

Suggested for you

View all

Krishnaveni Shanmugabalu

Sarfaraj Ansari

Narendra Bariya

Aymen Amri

David Mccarter

Forum Statistics

Please welcome our newest member V V.
3,077,358 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 8 new threads, 21 new posts, and 146 new users.
In last week, the most popular thread is 'Case statement Else part Not Working Properly .'.