get the user name and domain name from an email address

Solutions on MaxInterview for get the user name and domain name from an email address by the best coders in the world

Search
showing results for - "get the user name and domain name from an email address"
Simon
08 Jan 2019
1DECLARE @Email     VARCHAR(50) = 'helper@sql-server-helper.com'
2
3SELECT SUBSTRING(@Email, 1, CHARINDEX('@', @Email) - 1) AS [User Name],
4       SUBSTRING(@Email, CHARINDEX('@', @Email) + 1, LEN(@Email)) AS [Domain Name]
5
source
similar questions
create email address from first and last name in sqlsql query for login with email or usernamegrouping by email domain mysql
queries leading to this page
find domain name of email addresshow to get an email with your domain namefind email address using domain nameget name from email address pagesget username from email loginget email address for domain namehow to get domain name in emailhow to get email on domain nameget email address from domain nameemail how to get email with my domain namehow to get email with a domain nameget email with domain namegetting an email address with your domain nameget email address with domain namecan i get an email address with a domain nameget the user name and domain name from an email address