case when then else end IN select clause ---------------------------------------- Key: HHH-467 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-467 Project: Hibernate Core Issue Type: New Feature Components: core Affects Versions: 3.0.3 Environment: Hibernate 3.0.3, Oracle 9.2.0.1 Reporter: Albert Kam Assignee: Gavin King Fix For: 3.0.4 Original Estimate: 2 days Remaining Estimate: 2 days Please see my posting here : http://forum.hibernate.org/viewtopic.php?t=942197 In summary, i would like to request a new feature, so the 'select case when .. then .. else .. end' will work :) Please, our company want to use HQL as wide as possible, without having SQL native queries and HQL get mixed up. Thank you very very much. Sincerely, Albert Kam