I am trying to create a query HQL or Criteria that will return the result set sorted numerically, however, the numbers I need to sort, are in an varchar2 field. I looked at using a @Transient field, but could not get that to work. I also tried to use @Formula, but that would not work. Any help would be appreciated.

Hello,

In your mappin or annotation you can add a sort element and use a comparator class :

Look at the 2.4.6.1 :
http://www.hibernate.org/hib_docs/annot ... ntity.html

http://www.hibernate.org/hib_docs/v3/re ... ons-sorted

yeah, I guess I really wasn't wanting to create a new class just to do a sort. There are several ways to do it if i start creating new classes. Seems like there should be an easier way to do such a simple task?