From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Function: Choose()

Purpose: The Choose() function is used to select an item from a list of arguments.

Usage: Choose(index, item1, item2, …, itemn, args)

Returns: Value of the indexth argument.

Examples and Special Cases

Choose(1, “apple”, “orange”, “banana”) = “apple”
Choose(2, “apple”, “orange”, “banana”) = “orange”
Choose(0, “apple”, “orange”, “banana”) = NULL
Choose(4, “apple”, “orange”, “banana”) = NULL