Re: Case when with 2 conditions

"Robert Klemme" <bob.news_at_gmx.net> wrote in message news:4eb0aqF1dh124U2_at_individual.net...
: 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...

:

not sure exactly what your suggesting to note, but there is no '==' in PL/SQL or SQL

in SQL and PL/SQL '=' is the comparison operator

in PL/SQL ':=' is the assignment operator

in the SQL UPDATE command SET clause, '=' doubles the assignment operator

++ mcs Received on Fri Jun 02 2006 - 09:34:54 CDT