This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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?