I have a field that is an email address. This address always follows the format of "email@example.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