Re: Using Upper and Lower functions in Criteria

[David Hainlin]

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]