choose :- New function in sql server denali

CHOOSE

Retruns value at specified index from list of values



lets see it

SELECT Choose (1, 'a', 'b', 'c', 'd')

If no value presents at specified index than it returns null

SELECT Choose (7, 'a', 'b', 'c', 'd')