I am trying to write Hibernate query.I have one column in database.I want to take numbers from the 2nd position till end of the field and compare it to some number.

Here is the code.



I want to put condition like if number starting from the 2 nd position of column "visit" is greater than 340.I do'nt know how to use substring method.

I will appriciate you help.

Thanks.

It can give you an idea how to make your hql query. Below one queries visit column for 4 characters from 2nd character whose value is greater than 340.