Join using trim

[John Varghese]

Hi,
   I want to do a join on 2 tables as follows

----------------------------------------------------------------
    select vendor_email from vendor_master v, lot_master b
    where b.lot_id = 43
    and trim(v.vendor_code) = trim(b.vendor_code);
----------------------------------------------------------------

The vendor_code is of type varchar2(50)

Hoe to accomplish this in torque

Thanks
John V