O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required