firstname.lastname@email.com/IMCLientName
我只需要出现在@符号之前的字符.
我试图找到一种在sql中执行此操作的简单方法.
DECLARE @email VARCHAR(100) SET @email = 'firstname.lastname@email.com/IMCLientName' SELECT SUBSTRING(@email,CHARINDEX('@',@email))
