File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to remove the Employee ID from Query. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to remove the Employee ID from Query." Watch "How to remove the Employee ID from Query." New topic
Author

How to remove the Employee ID from Query.

Sandeepesh shah
Greenhorn

Joined: Feb 11, 2010
Posts: 10
Dear All,
I am executing a Qry like Select EmpName from Empolyee;

Result : RajesKumar#00214588

But I wnat to retriew the value only like RajeshKumar and want to remove the EmployeeID from result.

So How I can get the Substring in SQL Query.
Sridhar Santhanakrishnan
Ranch Hand

Joined: Mar 20, 2007
Posts: 317
Take a look at combining CHARINDEX() with SUBSTRING()
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to remove the Employee ID from Query.
 
Similar Threads
Srping+Hibernate bad configurated causing huge memory consumption
EJB QL Question
Avg(...) aggregate function
Display table with decimal values like 0.2 problem
Hibernate DetachedCriteria: how to leave out a given object from the results?