Re: anyone way to use a wildcard in a decode?

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 11 Jun 2003 20:54:12 -0700
Message-ID: <73e20c6c.0306111954.718358ae@posting.google.com>

rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0306111155.78871856_at_posting.google.com>...
>
> ME>select decode(y,'%A%','XXXXX') from xx;
>
>
> DECOD
> -----
>
>
> 1 row selected.
>
> ME>select decode(y,'%A%','XXXXX','BLAH') from xx
> MASTER_TEST2_at_BOBAIRD>/
>
> DECOD
> -----
> BLAH
Would:
select decode(instr(y,'A'),0,'BLAH','XXXX') from xx; do what you looking for? Or vicky-the-versa on the decode result strings?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed Jun 11 2003 - 22:54:12 CDT