Restrictions hql QBC

Hql Operator	QBC Operator	Description
=	Restrictions. eq ()	Equal to equal
<>	Restrictions. Ne ()	Not equal to not equal
>	Restrictions. gt ()	Greater than greater
> =	Restrictions. Ge ()	Greater than or equal to greater than or equal
<	Restrictions. LT ()	Less than less
<=	Restrictions. Le ()	Less than or equal to less than or equal
Is null	Restrictions. isnull ()	Equal to null
Is not null	Restrictions. isnotnull ()	Non-null value
Like	Restrictions. Like ()	String mode matching
And	Restrictions. And ()	Logic and
And	Restrictions. conjunction ()	Logic and
Or	Restrictions. Or ()	Logic or
Or	Restrictions. disjunction ()	Logic or
Not	Restrictions. Not ()	Non-logical
In (list)	Restrictions. In ()	Equal to a value in the list
Not in (list)	Restrictions. Not (restrictions. In ())	Not equal to any value in the list
Between x and y	Restrictions. ()	Any value in the closed range XY
Not between x and y	Restrictions. Not (restrictions... ())	Less than X or greater than Y