Articles → SQL SERVER → Choose Function In The SQL Server
Choose Function In The SQL Server
Purpose
Example
SELECT CHOOSE(0, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')
Union
SELECT CHOOSE(1, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')
Union
SELECT CHOOSE(2, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')
Union
SELECT CHOOSE(3, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')
Union
SELECT CHOOSE(4, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')
Union
SELECT CHOOSE(5, 'Apple', 'Banana', 'Mango', 'Grapes', 'Strawberry')
Output
Click to Enlarge