SQL Server 2000 query question.

[GtPrOjEcTX]

Pretty simple question...

Here's an example query I'd like to do...

Select * from sampleTable where itemID = 1 OR itemID = 2 or itemID = 56

is there a way I could save line space and do something like...

Select * from sampleTable where itemID = (1,2,56)

same way for ANDs.

Thanks,

Craig

 

[MattCo]

I will try to look it up, but there is something like Is Member().

-MC

 

[Haircut]

I think you can use
select * from sampletable where itemID in (1,2,56)

 

[calpha]

Originally posted by: Haircut
I think you can use
select * from sampletable where itemID in (1,2,56)

You are correct sir.

 

[GiLtY]

Originally posted by: Haircut
I think you can use select * from sampletable where itemID in (1,2,56)

Yep, he's got it.

 

[GtPrOjEcTX]

Originally posted by: Haircut
I think you can use
select * from sampletable where itemID in (1,2,56)

awesome. I knew there was something to that effect.