Sql Query to get domain Name from email column
Posted: June 27, 2011 Filed under: SQL Server | Tags: Microsoft SQL Server, SQL, T-SQL 3 Comments »The following T-SQL Query will retrieve anything that is after the @ symbol, the query can be very useful for retrieving the domain of an email address
SELECT SUBSTRING(T.Email,(CHARINDEX('@',T.Email)+1),LEN(T.Email) - (CHARINDEX('@',T.Email))) as DomainName FROM EmailTable T
Advertisement
i need a query to get a name like below
if email is friends@gmail.com
the o/p will be like this:
friends
Try this query
SELECT SUBSTRING(T.Email, 0, (CHARINDEX('@',T.Email)+1)) as EmailNamePart FROM EmailTable Tmy email id is:sivareddy.mygo[at-the-rate]gmail.com