Allows returning one of the values provided in the @val parameters, indicated by the @index parameter. The returned data type is the same data type of the selected value.

Syntax

CHOOSE(@index, @val_1, @val_2[, @val_n])

Parameters

•@index: Index, starting at 1 (one), of the value. This is a mandatory parameter

•@val_1: Value of the option with index 1 (one). This is a mandatory parameter

•@val_2: Value of the option with index 2 (two). This is a mandatory parameter

•@val_n: Value of the option with index n, in which n is greater or equal to 3 (three). The limit of parameters is undefined