You are allowed to call SQL functions from HQL.
Please send questions like this to the user forum in future, TIA.
Sander Hofstee wrote:
Hi,
I am using Hibernate 2.0.2 with SAPDB 7.4. I am trying to order by two
concatenated columns,
where both columns are not-null false.
the query is somtehin
Hi,
I am using Hibernate 2.0.2 with SAPDB 7.4. I am trying to order by two
concatenated columns,
where both columns are not-null false.
the query is somtehing like
select person.lastname, person.firstname from Person.class.getName()
person order by (upper(person.lastname || person.firstname))
