Solved

Getting partial values from SQL Server columns

Posted on 2004-03-26
2
205 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 50 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now