db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Newton <d...@solaraccess.com>
Subject Re: How to use trim in select clause
Date Wed, 21 Jan 2004 14:41:23 GMT
On Wed, 2004-01-21 at 01:00, John Varghese wrote:
>  What is the Torque equivalent for the following
>  select query run from sql prompt
> ---------------------------------------------------------------------------------------------

>     select * from  product_revision where UPPER(TRIM(REVISION_NO))='R19870'
> ---------------------------------------------------------------------------------------------
> I am interested in the trim part.

Probably directly coding the SQL query :)

Otherwise you can use any Java method (including the String methods) to
massage Criteria parameters and use a Criteria like you normally
would--they don't care what you give 'em.

Dave



---------------------------------------------------------------------
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