Avatar of Michael Larimore
Michael Larimore
Flag for United States of America

asked on 

How can I split a string into 2 parts in a Microsoft Access Query

I have a field that is an email address.  This address always follows the format of "john.smith@gmail.com".  The names are not always the same length.  I would like the output to read "john smith".  Any help with this would be appreciated!
Microsoft AccessMicrosoft SQL Server

Avatar of undefined
Last Comment
crystal (strive4peace) - Microsoft MVP, Access

8/22/2022 - Mon