Case Statement use in HANA SQL Script
In one of the last post Use of CASE Statement in HANA SQL Script we know a simple use of CASE statement .
Here a slightly different use of CASE statement in SQL Script. Below as highlighted we can directly put a condition in the WHEN part and if the condition is true, hence forth the THEN part is executed. The condition in the when can be a complex one.
Debug Details-
Now we can put a little complex condition in the WHEN clause.
Debug Details-