Taking Just Domain from Email Address

B

BDM

Hi,

I'm trying to write a query where I take just the domain from an email
address. I'm trying to group and count a list of 100,000 email addresses by
provider.

But, I'll need to convert all of the email address into just provider. For
example [email protected] wouldneed to become "yahoo.com" and
[email protected] would need to become just "hotmail.com".

Is there away to just keep everything to the right of the @ sign or delete
everything to the left of it?

Thanks for your help.
 
Top