You can use query below:
DECLARE @Email VARCHAR(50) = 'info@ercanopak.com'
SELECT SUBSTRING(@Email, 1, CHARINDEX('@', @Email) - 1) AS [User Name],
SUBSTRING(@Email, CHARINDEX('@', @Email) + 1, LEN(@Email)) AS [Domain Name]
User Name Domain Name
----------- -------------
info ercanopak.com
Related posts:
Search text in all tables in SQL Server
How to concatenate text from multiple rows into a single text string in SQL server?
Convert a Comma-Delimited List to a Table in SQL
Drag and Drop objects from Object Explorer to the Query Window in SQL Server
Create, Alter, Drop and Execute SQL Server Stored Procedures