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
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
