Optimize code with CASE

Use CASE…END statement whenever checking for conditional statements wherever applicable. It is not only easy to use but it sometimes takes half the execution time then IF…ELSE..END statement which ultimately speeds up the execution time of our application.

Below is the preference

CASE…END
IF…ELSE…END
INRANGE