SQL has two logical functions – CHOOSE and IIF.
The CHOOSE function returns an item from a list of values, based on its position in the list. This position is specified by the index.
In the syntax, the index parameter specifies the item and is a whole number, or integer. The val_1 … val_n paramete...