Hi,
I'm facing a peculiar issue where in I have to query with a constraint on a nullable field. say something like
select * from soldto soldto where nvl(soldto.rowstate,0) != 2000. Is there a way, I can implement this in Hibernate? Or do I have to resort to native SQL?

Thanks for your Help
Dheepak.

I think you neet to resort to SQL queries:
http://www.hibernate.org/hib_docs/v3/re ... -nativesql

Hi

You can use coalesce Hibernate function.

Example:
COALESCE(soldto.rowstate,0) != 2000

Regards,
Adam Woźniak

PS. rate if helps.