How to find the domain in mail id?

BEGIN

DECLARE @email NVARCHAR(100);

SELECT LEFT(@email, CHARINDEX('@', @email)-1) 'Name' , RIGHT(@email, LEN(@email) - CHARINDEX('@', @email)) 'Domain_Name';

END

Ashok8y ago

Hi Manas,

i want output like this

name domain_name

abc gmail.com

bcd yahoo.com

please help me

Thanks

Hi Ashok,

Can you give me an example of the output you are expecting?

Ashok8y ago

hi

i didn't get the answer by using that query

how can i saparate the only names and mail id's?

Thanks All

Ashok

I am sure not a single word of that answer is being understood by who asked the question.

SQL:

BEGIN

DECLARE @email NVARCHAR(100);

SELECT RIGHT(@email, LEN(@email) - CHARINDEX('@', @email));

END

C#:

string email = "[email protected]";

string domain = email.Substring(email.IndexOf("@") + 1);