Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare multiple items in where - short form?

Status
Not open for further replies.

CHeighlund

Programmer
Jun 11, 2007
163
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top