This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
 
jQuery in Action, 3rd edition