Hi
i need to use CASE statement or DECODE is the select part of my query, is there any way to do this. the reason being that i need to return a diferent column depending on the value of another. I just get the undefined alias error when trying to use either. as we are using HQL for all other queries i don't want to have to use jdbc... any help would be greatly appreciated.

Hibernate version:
2.1.6

Try to use Interceptors, http://www.hibernate.org/hib_docs/reference/en/html/manipulatingdata.html#manipulatingdata-interceptors

Or Lifecycle