db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Eade <se...@backstagetech.com.au>
Subject Re: Using Upper and Lower functions in Criteria
Date Sat, 20 Dec 2003 02:04:28 GMT
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?*
>

try:

            criteria.getCriterion(YourPeerPeer.ENAME).setIgnoreCase(true);

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au





---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message