What is choose function in Denali? Explain with example.

Answer:

Given a list of values and a position, the Choose function will return the value at the indicated position.

The syntax is

Choose ([Position], [Value1],[Value2],…,[ValueN])

e.g.

Select Choose (1,'Value1', 'Value2','Value3') As [Choose Demo]



/*

	Choose Demo

	------------

	Value1

*/

In this example, we have specified the position as 1 and hence out of the two values, the first appears as the result.