?
Solved

Getting partial values from SQL Server columns

Posted on 2004-03-26
2
Medium Priority
?
214 Views
Last Modified: 2010-04-17
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.
0
Comment
Question by:venkatraman_r
2 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 200 total points
ID: 10687030
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
 

Author Comment

by:venkatraman_r
ID: 10687301
Very Good. It worked well.

Thanks a lot.

Rgds
Venkat.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
Progress
Screencast - Getting to Know the Pipeline

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question