Operator 'LIKE' multiple ???

Hello,
I have a request like this :

select * from table1
where cond like

   (select %||distinct champ||%
    from table 2 where table1.champ1 = table2.champ1)

But Like don't take mutliple values (instead of 'in' operator).

How can i do ? Thanks Received on Tue Jul 31 2001 - 13:34:23 CEST