Using 'AND' and 'OR' in decode statement 1

[laurenbattaglia]

Can you use 'AND' and 'OR' operators in a decode statement and if so, what is the syntax?

Thanks, Lauren

 

[SQLBill]

What do you mean by a decode statement?

I'm not aware of Microsoft SQL Server having any decode statement.

-SQLBill

 

[laurenbattaglia]

I am not sure if I am in the right forum or not. I am using Info SQL Designer and I am trying to do an if statement that checks if condition 1 and condition 2 are true. I have been using a decode statement, but I am unsure how to do this while testing more than one condition.
Any help you could provide would be great.

Lauren

 

[sunila7]

DECODE statment is used in Oracle statement. I think you should post your query in Oracle forum.

This is the link to Oracle 8i forum forum186



Sunil

 

[royjimenez]

DECODE is similar to
CASE

look up "CASE" in the select syntax.

Sintaxis
Función CASE sencilla:

CASE input_expression
WHEN when_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END