When you use a range test in a Case clause, the value on the left side of the To must always be lower than the value on the right side.

Question

Quizplus · Accepted Answer

This is true because the range test expects a lower value on the left and a higher value on the right in order to create a range of values to match against. If the values were reversed, it would create an invalid range and may produce unexpected results.

When You Use a Range Test in a Case Clause