Getting partial values from SQL Server columns

Greetings!

I have a sql server table with a column called "e_email". This column holds the values

venkat@india.com
chandar@india.com
ram@india.com

I want a query which gives me the output as below

venkat
chandar
ram

Someone pls suggest me how do i write this query.

Thanks,
Venkat.
venkatraman_rAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
Hi venkatraman_r,

Select Left(e_email,charindex('@',e_email)-1) As EmailName

Tim Cottee
Brainbench MVP for Visual Basic
http://www.brainbench.com
0
 
venkatraman_rAuthor Commented:
Very Good. It worked well.

Thanks a lot.

Rgds
Venkat.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.