Selecting a specific value within a case expression
09:06 15 May 2020

I need help with selecting a specific value within a CASE expression.

For an example

SELECT CASE WHEN Field1 >= (Field2 = 1) THEN Answer
            WHEN Field1 <  (Field2 = 1) THEN No Answer
            ELSE Question END AS Field3

I want to be able to select a specific value in Field2 within the CASE expression

sql