[Solved] Select @ before values
[ad_1] This is for MS SQL Server. You can easily replicate this if you use any other RDBMS declare @email varchar(100) set @email=”[email protected]” select substring(@email,1,charindex(‘@’,@email)-1) 3 [ad_2] solved Select @ before values