/SQL/Get the User Name and Domain Name from an Email Address

Get the User Name and Domain Name from an Email Address

DECLARE @Email     VARCHAR(50) = 'helper@sql-server-helper.com'

SELECT SUBSTRING(@Email, 1, CHARINDEX('@', @Email) - 1) AS [User Name],
       SUBSTRING(@Email, CHARINDEX('@', @Email) + 1, LEN(@Email)) AS [Domain Name]

Source: sql-server-helper.com

Similar codes

0 vote212 views1 answer
Primary key start from number
SQL
0 vote207 views1 answer
Foreign key multiple columns
SQL
4 votes201 views2 answers
Sql offset
SQL
0 vote188 views1 answer
Odd record sql query
SQL
0 vote183 views1 answer
Mysql update sum same table
SQL
0 vote253 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote192 views1 answer
Copy Table from SQL to CSV
SQL
0 vote205 views1 answer
Insert data from stored procedure into table
SQL
0 vote202 views1 answer
How to locate pg_hba.conf file
SQL
0 vote199 views1 answer
How to check common records in 2 table
SQL