Solved

Getting partial values from SQL Server columns

Posted on 2004-03-26
2
210 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
[X]
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
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

This article will show, step by step, how to integrate R code into a R Sweave document
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

726 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