when i used projections in hibernate i am able to get each propety list using criteria queries....my result will give me a list of NPANXXX Integers
i need first three numbers means NPA of each row ,how to get this using hibernate criteria queries or using HQL queries...

i do not want to iterate resultset or list of columns and get sub string of those result set...i need all sub string logic should happen at Data base only.............
example:

201xxxx
202xxxx
203xxxx,

i need my result as

201
202
203


Plz help me ,







Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

you can use java string manipulation.....

st = st.getsubstring(0,3);

Check the documentation for your database. Hibernate usually maps database-specific functions to HQL. For example, if I use MySQL I can use the substring() function in HQL.

http://dev.mysql.com/doc/refman/5.1/en/ ... _substring