Hibernate version:3 Alpha

Name and version of the database : JBoss 4.0.0

I need to write an HQL that returns a boolean depending on the contents of another value.

i.e. I need to display ID, Name, TypeID, IsTrue from a table called MyTable where TypeID is a foreign key and IsTrue holds true/false depending on the value of the TypeID (If TypeID has a string then IsTrue is assigned true, if TypeID has a null then IsTrue is assigned false).

Note : IsTrue is an attribute that does not exist as a field of a table, but gets created at the query execution to .


please help.