Re: Operator 'LIKE' multiple ???

refufr_at_netcourrier.com (OneKha) wrote in message news:<73f4d92b.0107310334.5ef55644_at_posting.google.com>...
> 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

read the oracle sql manual to see all the oracle sql functions available to you. You will find lots to be creative with. It comes online with all the other oracle docs.

select *
from t1
where exists

   (select null
    from t2
    where t1.key = t1.key
    and instr(t2.string,t1.string) > 0)
/ Received on Thu Aug 02 2001 - 16:58:36 CEST