Case when with 2 conditions

From: Carlos Antonio <carlosantoniovazquez_at_gmail.com>
Date: 2 Jun 2006 06:47:19 -0700
Message-ID: <1149256039.122215.145200@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 Received on Fri Jun 02 2006 - 08:47:19 CDT