sql syntax ... join

Hi, I like to know if it is possible to make a simple join but based on an expression like the following one

select * from table1 a, table2 where a.trim(cod) = b.cod

thanks Received on Fri Jan 16 2004 - 09:38:50 CST