SubString and CharIndex

Substring(EmailAddress, 0, Charindex('@',EmailAddress))
原文地址:https://www.cnblogs.com/sandy_liao/p/1887598.html