[email protected]
aabernet : - SUBSTRING(emailaddress,1,charindex('@',emailaddress)-1)
fuller.edu : - right(emailaddress, charindex('@',reverse(emailaddress))-1)
edu : - right(emailaddress, charindex('.',reverse(emailaddress))-1)