Re: Case when with 2 conditions

"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 - 09:08:50 CDT