aspose 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
Avg(...) aggregate function
EJB QL Question
Srping+Hibernate bad configurated causing huge memory consumption
Hibernate DetachedCriteria: how to leave out a given object from the results?
Display table with decimal values like 0.2 problem