Sql

Search

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]

Comment

PREVIOUS	NEXT

Code Example
Sql :: SQL Error When Inserting Duplicate Values
Sql :: list databases in sql server
Sql :: postgresql allow remote connections
Sql :: select lowest values sql
Sql :: sql script to delete duplicate records in a table
Sql :: sql int size
Sql :: Insert results of a stored procedure into a temporary table
Sql :: sql into vs insert into
Sql :: timing sql queries
Sql :: kill mysqld_safe process mariadb
Sql :: sql server isnull function nor working count
Csharp :: minimize window form c#
Csharp :: read text file to string c#
Csharp :: unity cycle children
Csharp :: how do i convert to base64 c#
Csharp :: check version of asp.net core
Csharp :: asp.net c# write string to text file
Csharp :: how to remove a component from an object in unity
Csharp :: wpf numeric only textbox
Csharp :: unity set object scale
Csharp :: unity application quit
Csharp :: unity run void from another script
Csharp :: c# get all bytes of a file
Csharp :: c# int to bool
Csharp :: resize image c#
Csharp :: query parameter c# controller
Csharp :: c# insert into database
Csharp :: stop process c#
Csharp :: shaking camera in c#
Csharp :: how to maximize but show taskbar c#

Search

SQL

Get the User Name and Domain Name from an Email Address

ADD CONTENT