You are viewing content for 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


Returns the result of multiple if statements.


Check COUNTRYNAME_ for instances of “Spain” and “Argentina”. For “Spain”, return “Great”. For “Argentina”, return “Cool”. If COUNTRYNAME_ evaluates to neither “Spain” nor “Argentina”, return “Other_Country”.

case(SALES.COUNTRIES.COUNTRY_NAME = "Spain", "Great", SALES.COUNTRIES.COUNTRY_NAME = "Argentina", "Cool", "Other_Country")


case(bool expr1, result1, bool expr2, result2, . . ., bool exprN, resultN, else)


  • exprN : expression returning bool
  • resultN : expression to evaluate and return if exprN evaluates to true
  • else : expression to evaluate and return if none of exprN evaluate to true


    <type> expression


Function case returns an a value dependent on which of its test conditions are satisfied. For a pair of expressions (say, the first and second) case evaluates the first and returns the second if the evaluation is true. If it is not true, case tries the same thing with the second pair. This continues until a match is found. If there is no match, case returns the final expression (else).