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
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: 17410

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

An IDE is no substitute for an Intelligent Developer.
I agree. Here's the link:
subject: finder
It's not a secret anymore!