Substring(EmailAddress, 0, Charindex( '@',EmailAddress)) 转载于:https://www.cnblogs.com/sandy_liao/archive/2010/11/25/1887598.html