We then use LEFT(Email,PeriodLocation-1) to get the first PeriodLocation-1 left most characters from our email address. We subtract 1 from the character location of the first period since we only want the characters before the period. In our example this is LEFT(“jim.smith@breadmakers.com”,3) which will return jim all in lower case since our email address was all in lower case. We then use PROPER(FirstName) to return the first name in its proper case with the first character capitalized. In our example PROPER(“jim”) will return Jim as the final result.

How to Extract the First Name From an Email Address - 62