/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

2 votes339 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote343 views1 answer
Sql clear table
SQL
14 votes364 views3 answers
Delete all records from table except sql
SQL
-2 votes365 views2 answers
Union all in sql
SQL
11 votes371 views3 answers
How to get last row of table in sql
SQL
0 vote338 views1 answer
Mysql select where field is a value
SQL
0 vote353 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote335 views1 answer
Get number of tables in database sql
SQL
0 vote368 views1 answer
Oracle table privileges
SQL
0 vote361 views1 answer
Where name ends in SQL
SQL