How to use trim in select clause

[John Varghese]

Hi,
 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.

Pls help.
Regards
John