Hibernate version:
2.1.8

Hello,

I can't seem to find a break down of the hql grammer for hibernate2. I have a entity representing a street range as:



Given the street name and number I want the StreetRange instance that contains it.

I'd like to do a query like 'from Segment s where s.name = :name and :number between (s.start, s.end)'

I have legacy SQL doing this exact thing but I can't figure out the HQL equivilent.

Any help is much appreciated,

Kastor

What about:
from Segment s where s.name = :name and :number between s.start and s.end

Thanks Alesj,

This works for me.

Kastor