Microsoft® SQL Server 2012 Unleashed

The CHOOSE Function

The CHOOSE 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. The syntax is as follows:

Click here to view code image

CHOOSE ( index, val_1, val_2 [..., val_n ] )

The index value is an integer expression that represents a 1-based index into the list of the items following it. If the provided index value exceeds the bounds of the array of values, CHOOSE returns NULL.

The code shown in Listing 44.6 provides an example of using the CHOOSE function to translate the ShiftID value to a string representing the type of work shift.

LISTING 44.6 CHOOSE Function Example

Click here to view ...