Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case when with 2 conditions
Mark C. Stock wrote:
> "Carlos Antonio" <carlosantoniovazquez_at_gmail.com> wrote in message
> news:1149256039.122215.145200_at_h76g2000cwa.googlegroups.com...
> : Hello,
> :
> : How can I use the case when statement, but with 2 conditions?
> :
> : is it like ...
> :
> : case
> : when (field1 = 'A' and Field2 = 'B') then 'C'
> : else 'Z'
> : end as whatever_result
> :
> :
> : ...???
> :
> :
> : Any help will be appreciated
> :
>
> try it...
Carlos, note also the usage of "=" vs. "=="...
robert Received on Fri Jun 02 2006 - 09:29:46 CDT