/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 votes127 views2 answers
How to start mysql in terminal
SQL
0 vote136 views1 answer
Mysql 1 hour ago
SQL
1 vote164 views4 answers
How to check table in postgresql from terminal
SQL
4 votes167 views3 answers
Postgres drop all tables
SQL
0 vote149 views1 answer
Sql query to find duplicate email address
SQL
0 vote132 views1 answer
Wordpress database query change url
SQL
10 votes90 views2 answers
Django mysql
SQL
9 votes129 views4 answers
How to remove duplicate in sql
SQL
0 vote142 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote148 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL