This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes finder Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "finder" Watch "finder" New topic


John Faulk

Joined: Feb 05, 2001
Posts: 4
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?
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15959

It looks like you'll have to write a Java finder to do your case conversion:

Customer surveys are for companies who didn't pay proper attention to begin with.
wood burning stoves
subject: finder
Similar Threads
case insensitive search in finder
How to write this find Query Element
Little Thing about ejb QL
How to Entity Beans in Jboss !
Alternative to LIKE Clause