I have the following code:


SELECT
A,
IF B > C
(SELECT B)
ELSE
(SELECT C),
D
FROM MyTable


A, B, C and D are integer columns in MyTable.
I get "incorrect syntax near the keyword 'IF' "
I'm playing with parentheses but I can't get it to work.
What's wrong with my syntax??

Thanks,

Bjorn

Which database software are you using ?

Oracle -

select a, (case WHEN B > C THEN B ELSE C END)

I use Microsoft SQL. I got it to work with the CASE statement.

Thanks,

Bjorn

That is what I thought. Next time you would be better off posting your question to the database forum you are using.