Query Language case-insensitive Like

[hurzeler]

Hello,

Is it possible to do a case-insensitive LIKE query with EJB3. If yes how if not is there another way to do this.

example:
SELECT OBJECT(s) FROM Site AS s WHERE s.name LIKE '%test%'

I want also 'TEST' as a result.

Thanks for your help.

[jjklappenbach]

try:

where lower(s.name) like lower('%test%')

The result should be the original value of the field.

-jjk