In a Case expression, when only one limiting value is known the programmer should use Is keyword instead of the To keyword when creating the expression.

Question

Quizplus · Accepted Answer

This is because the "Is" keyword checks for equality whereas the "To" keyword checks for a range of values. If only one value is known, it cannot form a range and therefore the "Is" keyword should be used instead.

In a Case Expression, When Only One Limiting Value Is