Taking Just Domain from Email Address

[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 (e-mail address removed) wouldneed to become "yahoo.com" and
(e-mail address removed) 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.

 

[Evi]

Instr & Mid will do the deed

DomainBit: Mid((e-mail address removed)

 

[BDM via AccessMonster.com]

Ok, that worked great.

Thanks very much.

Instr & Mid will do the deed

DomainBit: Mid((e-mail address removed)