CASE operation



This operation selects one of several values based on the specified conditions.

CASE When Sum > 1000 Then Sum Else 0 End

Next page: Rules for comparing two values