Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 21164 invoked from network); 20 Dec 2003 12:06:24 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 20 Dec 2003 12:06:24 -0000 Received: (qmail 70775 invoked by uid 500); 20 Dec 2003 12:06:20 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 70761 invoked by uid 500); 20 Dec 2003 12:06:19 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 70741 invoked from network); 20 Dec 2003 12:06:19 -0000 Received: from unknown (HELO mail.gft.com) (213.68.142.133) by daedalus.apache.org with SMTP; 20 Dec 2003 12:06:19 -0000 Received: from Ramah ([172.24.1.3]) by mail.gft.com with Microsoft SMTPSVC(5.0.2195.6713); Sat, 20 Dec 2003 13:06:18 +0100 From: "Ramah" To: "Apache Torque Users List" Subject: RE: Using Upper and Lower functions in Criteria Date: Sat, 20 Dec 2003 17:36:09 +0530 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <3FE2FEBE.6010604@comcast.net> Importance: Normal X-OriginalArrivalTime: 20 Dec 2003 12:06:18.0740 (UTC) FILETIME=[ACF10340:01C3C6F1] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N This works fine. Thank you, Ramah -----Original Message----- From: David Hainlin [mailto:dhainlin@comcast.net] 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: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org