I preface a lot of what I write with whether or not it is for a “practical” use. One of the Simple Talk authors used this function in a forthcoming article. and I realized I hadn’t heard of it before (or I forgot about it… which is not completely unlikely.) The practical use was to generate some data and have at least a little variety to the values.
The CHOOSE function has this syntax.
CHOOSE(item_to_choose, item1, item2 [,item3]…[itemN])
A position (starting at 1) for the item_to_choose, then a list of 1 to N (where N isn’t strictly defined, but