CHOOSE() function syntax with an example in SQL Server

1   CHOOSE() function syntax with an example in SQL Server

Introduction: 

In my previous posts we have seen what is Transact-Sql in sql server and What are new top features of T-Sql in server. This is one of the best sql server interview Questions and answers. Watch more ASP.NET, C#.NET, Jquery, Sql Server, HTML5, HTML, CSS, JQUERY UI Interview questions from here. 

Description: 

·        This function returns the item at the specified index from a list of values.

·        This function acts like an index into an array, where the array is composed of the arguments that follow the index argument. The index argument determines which of the following values will be returned.

  Example:

            SELECT CHOOSE (3, 'Manager', 'Director', 'Developer', ‘Tester’)

           Result:

           Developer


If you have any queries or suggestions, please feel free to ask in comments section.