Compare multiple items in where - short form?

[CHeighlund]

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.

 

[feherke]

Hi

[tt]in[/tt]

[b]where[/b] foo [b]in[/b] (x,y,z)

Feherke.

http://rootshell.be/~feherke/

 

[CHeighlund]

Thanks. Exactly what I needed.