hi,

i am trying to translate a ms sql select query into HQL.

query is :

select max( substring ( field ,1,5 )) as col1 from table1

max works ok with number fields.

but i have to substring a String field to get a integer then increment it.

i have searched the message board and faq. i am not not find any help.

what are my choices ? i don't want to load every value in a String array and loop.. that will increase response time.

do i have to use native sql ?


any tips are welcome.

iyyappan

Yes, you must use native SQL. We can't currently parse SQL functions with multiple arguments when they appear in the select clause.