I use Hibernate with EJB3.
LIKE is case sensitive. But usually search is case insensitive. If a table column has
"xxxxxx Telephonexxxxxx"
If user type keyword search: telePhone, it should return the result. Does Hibernate support case incensitive search/comparison? If not, what can I do? Thanks. Dave
where lower(order.orderNbr) like "everything in lowercase%"