Where statement

[Guest_imported]

Hi all,

I like to know if ANSI SQL supports IN operation in Where statement like in Jet SQL.

Here's I used to do in Jet SQL
"Select * From [cid] IN ('031256','031267')"
in ANSI, I'm doing something like,
"Select * From cid = '031256' AND cid = '031267'"

Thanks,

 

[grega]

Yes ...

select * from table where field in (val1, val2, ....)

Greg.