Ignoring case in EJB QL

Scenario: I have a nEJB QL query which searches for particular strings

SELECT DISTINCT OBJECT(u) FROM Users u WHERE u.name =?1

It works fine when I search for strings with the exact casing as the string stored in the DB. How can I extend this query so it can search for the same string with different casing.

I tried the example on this link:

http://forum.java.sun.com/thread.jspa?threadID=456558&messageID=2084058

but my JBOSS complains when I use the UCASE expression

Thank you

[526 byte] By [princa] at [2007-11-27 1:26:09]