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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
