Question: what is the difference between if-then statement and case statement?
Answer: Any kind of Boolean expression can be used in an If Then Statement. Each expression following an IF or ELSIF clause may be unrelated to the other expressions in the statement. In a Case Statement, however, a single Boolean expression is compared to a constant in each WHEN clause.