select SUBSTRING(EmailAddress,1,CHARINDEX('@',EmailAddress,1)-1) as [Email Address without domain],SUBSTRING(EmailAddress,CHARINDEX('@',EmailAddress,1)+1,len ...