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
solved Select @ before values
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
solved Select @ before values