Can I have multiple boolean expressions in a searched case sql statement?

Select CASE when ( a = be OR c = d OR e = f OR g = h ) THEN 'x' ELSE 'y' END from table_name The format is CASE..WHEN..THEN..ELSE..END You were just missing the WHEN.

Select CASE when ( a = be OR c = d OR e = f OR g = h ) THEN 'x' ELSE 'y' END from table_name The format is CASE..WHEN..THEN..ELSE..END. You were just missing the WHEN.

Thanks - I figured it out before seeing your answer. I feel really silly... – chama Jul 29 at 18:18.

I feel really stupid. I'm missing a when after the case... Should be select CASE when a = be OR c = d OR e = f OR g = h THEN 'x' ELSE 'y' END from table_name Then it works...

Glad you figured it out! But you should still give credit to Yuck for providing the first correct answer. :) – Michael Ames Jul 29 at 18:19 @Michael - I plan to.

I upvoted him, but I can't choose his as the answer for another few minutes... – chama Jul 29 at 18:23.

You missed WHEN keyword SELECT CASE WHEN a = be OR c = d OR e = f OR g = h THEN 'x' ELSE 'y' END FROM table_name.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.