/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

3 votes334 views3 answers
Mysql get table size
SQL
6 votes338 views5 answers
Get current date sql
SQL
1 vote354 views1 answer
Oracle user last connection date
SQL
10 votes352 views1 answer
Query to find object dependencies in oracle
SQL
0 vote328 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote348 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote385 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
4 votes383 views1 answer
Sql select limit range
SQL
10 votes344 views4 answers
Join with multiple conditions sql
SQL
12 votes362 views2 answers
Find duplicates mysql column
SQL