Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Getting partial values from SQL Server columns

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This is an explanation of a simple data model to help parse a JSON feed
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 …

840 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