Is there any way to do a compare of multiple items in a where clause without having to do a full 'where (foo = x or foo = y or foo = z)' style statement? I've got a three character char value that a report needs to separate by, but the overall grouping means that each possible report option has many different (minimum so far is five) sets of valid values for this field.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.