This works fine. Thank you, Ramah
-----Original Message----- From: David Hainlin [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 7:06 PM To: Apache Torque Users List Subject: Re: Using Upper and Lower functions in Criteria Ramah, Try something on the order or (in employee_peer) Criteria crit = new Criteria(); ... crit.add(ENAME, (Object) ("UPPER(" + ENAME + ") = '" + name.trim() + "'"), Criteria.CUSTOM); ... List vals = doSelect(crit); There may be other ways too but this technique will work for lots of SQL situations (like date ranges, for example). HTH David Ramah wrote: > 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?* > > Thanks in Advance, > Ramah > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
