CHOOSE and IIF Functions in SQL Server

dbtut March 8, 2019 MSSQL, TSQL

CHOOSE and IIF functions are logical functions.

CHOOSE function returns the value at the specified index from the specified list.

IIF function performs the work of the IF ELSE statement with one command. If it’s true, do something, if it’s not true, do something else.

Let’s make examples for a better understanding of CHOOSE and IIF functions.

SELECT CHOOSE ( 2, 'A', 'B', 'C', 'D' );

1	SELECT CHOOSE ( 2, 'A', 'B', 'C', 'D' );

SELECT CHOOSE([AddressID], 'A', 'B', 'C', 'D' )
  FROM [AdventureWorks2012].[Person].[Address]
  Where [AddressID] BETWEEN 1 and 3

SELECT CHOOSE([AddressID], 'A', 'B', 'C', 'D' )

FROM [AdventureWorks2012].[Person].[Address]

Where [AddressID] BETWEEN 1 and 3

SELECT IIF(1>2,'true','false') IsTrue;

1	SELECT IIF(1>2,'true','false') IsTrue;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux