CHOOSE() function syntax with an example in SQL Server

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



·        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.
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar