db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Varghese" <john.vargh...@kalzoom.com>
Subject How to use trim in select clause
Date Wed, 21 Jan 2004 06:00:17 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message