File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
How to remove the Employee ID from Query.
Joined: Feb 11, 2010
Mar 09, 2010 01:44:27
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.
Joined: Mar 20, 2007
Mar 09, 2010 01:52:05
Take a look at combining CHARINDEX() with SUBSTRING()
I agree. Here's the link:
subject: How to remove the Employee ID from Query.
EJB QL Question
Srping+Hibernate bad configurated causing huge memory consumption
Avg(...) aggregate function
Display table with decimal values like 0.2 problem
Hibernate DetachedCriteria: how to leave out a given object from the results?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015