I need assistance with the CASE statement in a where clause. I have table of TEMPERATURE I need to convert the following pseudo code into the SQL statement.
I have a TEMP field - I need to return the 'value' based upon the value.
To return 3 new INT fields GOOD, ,OK, FAIR - NOTE: A VALUE CAN BE BOTH GOOD AND OK.
if (TEMP >= 68.7 &&TEMP <= 83.30)
if (TEMP >= 70.16 &&TEMP <= 81.84)
else if (TEMP > 81.84 && TEMP < 83.30)