Finding an @ in an e-mail address.

[New2SQL]

having a prob with the above. not sure what is the best way to find out what comes after the @ in an e-mail address.

For example, if i was to have the following e-mail address@

firstname.lastname@myemail.com

is there an expression to use to shrink the above so that i can only see the "myemail.com"?

thanks for your help.

 

[Bat17]

= Mid(MyAddy, InStr(MyAddy, "@") + 1)

Peter

PS you might like to go in and delete the duplicate post