Meaningless Drivel is fun!*
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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.