Yes, it would be very interesting to learn more about CHOOSE. While I don't currently run 2012, I think a question that applied more to the functioning of the index argument in CHOOSE would help us to learn more from it.

While an operating lab-type example is fine, running the query and getting the correct answer doesn't always necessarily solidify an understanding of the principles of the function's operation.

As has been suggested before, having the data present in the question would have been a big asset, as I did attempt to download the 2008 version of AdventureWorks, but was met with incompatibility issues.

Way too much trouble to answer a question.

Thanks for the question and for bringing CHOOSE to the forefront.