What is CHOOSE Function in SQL Server?


CHOOSE Function was introduced with SQL Server 2012. This function returns the item from the given set of items at the specified index.
Syntax: CHOOSE(index, item1, item2, item3,…itemN)
Example:

Select Choose(3,'I','Love','My','India')


Result: My
Note: 3 is the index number in the given set of items.