Is there any possibility to use UPPER and LOWER function of SQL in Criteria?
*Ex: Select eid from employee where upper(ename)='XYZ'. How to create Criteria for the above Query?*
try:
criteria.getCriterion(YourPeerPeer.ENAME).setIgnoreCase(true);
Scott
-- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
