Is it possible to compare a single value to many in a single statement? Here is what I am attempting to do:
1. Users lands on page and via a cookie check function they are identified.
2. A query is sent to the headcount table to determine their Skill Type which also serves as the security level access identfier in this case.
3. Send the Skill Type to a function that will determine what table of reporting links they are authorized to view.
At this point I have a problem. I have basically two groups of skill sets, and two sets of reports, one for each level. There are three skill types for each group. Can I compare each set as a group(array) without having to write individual ElseIF or CASE statements?
For example, set one would be comprised of:
Skill Type
--------------
Director
Operations
Support
In the receiving function can I compare the Skill Type passed from the original page to a group of values with the same result? Kind of like an IN statement in SQL if that makes this more clear.
I hope that gives a good explanation of what I am trying to accomplish. I am attempting to avoid unneccessary code duplication if possible.