Using the switch statement in a query

[sk8er1]

I just used a switch statement in a query. Its really powerful feature. Its better than stringing along an IIF statement. What do you guys think?

 

[gol4]

I think if used properly a switch function will work well in place of a lengthy IIF function. I have also used choose as well but generally I find I have to use these in places where a database is not well designed. A join on a properly indexed table is faster then having to evaluate each possible expression.

Switch evaluates all of the expressions, even though it returns only one of them. For this reason, you should watch for undesirable side effects.