select SUBSTRING(Email,1,CHARINDEX(‘@‘,Email)-1)from StudentInfo
select SUBSTRING(Email,CHARINDEX(‘@‘,email)+1,LEN(Email)-CHARINDEX(‘@‘,Email)) from StudentInfo
select SUBSTRING(Email,1,CHARINDEX(‘@‘,Email)-1)from StudentInfo
select SUBSTRING(Email,CHARINDEX(‘@‘,email)+1,LEN(Email)-CHARINDEX(‘@‘,Email)) from StudentInfo
原文：https://www.cnblogs.com/xdl1111/p/8671288.html