SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP

SQL Choose() Function in SQL Server 2012

SQL Choose() function introduced with SQL Server 2012 returns an input argument from a list of input values at the desired index which is specified as an input arguement as well

CHOOSE (index, arg1, arg2 [, argN])
SQL Choose Function

The first input argument to the SQL Choose() function is "index" and it is in integer data type. The input arguments can be thought as an array with index starting from 1.

SQL CHOOSE() Function Samples

In this T-SQL tutorial, SQL programmers can find Choose() function sample codes which can help to understand where and how to use SQL Choose() function.

Choose() Function and Index Argument

The input index parameter or index argument to Choose() sql function can be a static integer value, or can be an integer variable parameter.

DECLARE @index int = 2
 Choose(1, 'First','Second','Third','Fourth','Fifth') [Static Index],
 Choose(@index, 'First','Second','Third','Fourth','Fifth') [Variable Index]
Choose SQL Function

SQL CHOOSE function sample TSQL code

Choose() Function with Invalid Index

Of course it is possible to set the 1-based index value to zero (0) or to an index that is out of the range of the input array. In these cases the SQL Server Choose() function returns NULL as return value.

 CHOOSE(0, 'T-SQL', 'PL/SQL', 'OSQL'),
 CHOOSE(999, 'A', 'B', 'C')
SQL Code

invalid index as SQL Server Choose() function argument

The index argument of the Choose() function can be NULL instead of a valid integer value. In such cases again, SQL Server function Choose() will return NULL value as output.

declare @i int = NULL

Choose() Function as an Expression to Concat() Function

Here is an other t-sql sample code where SQL Choose() function and Concat() function are used together in single SELECT statement. Note that the SQL Server Choose() function is used as an input expression argument to Concat() string concatenation function.

DECLARE @months int = 1
 CONCAT('Last day of ', @months, ' months later is ',

SQL Server CHOOSE function with EOMonth Function

I hope T-SQL developers are ready to use SQL CHOOSE() function in their codes. If you wonder other T-SQL functions introduced with SQL Server 2012, you can find a list of functions here New T-SQL Functions in SQL Server 2012 and here SQL Analytic Functions in SQL Server 2012

SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.