This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
hi, i could not find a way i can use the equivalent of sql UPPER and LOWER in ejb query language. basically if i have a 'employee' table with column 'name' and 1 entry for Jack. if the user searches for 'jack' , i should return the row. but the finder-query does not allow me to use anything but the below: <finder-query>< ![CDATA[(like name $0)]]></finder-query> so unless i store the table data in lowercase or uppercase (which i don't want to), i cannot do a case-insensitive search. advise anyone?