Re: Case when with 2 conditions

From: Carlos Antonio <carlosantoniovazquez_at_gmail.com>
Date: 2 Jun 2006 12:46:54 -0700
Message-ID: <1149277614.807333.6480@j55g2000cwa.googlegroups.com>

It worked. It was a mistyping.

Thanks

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...
Received on Fri Jun 02 2006 - 14:46:54 CDT