Help With Simple SQL Code(making field equal to multiple values) 2

[Jdbenike]

select distinct a.Homelaborlevelname5,
a.HomeLaborLevelDsc5
from vp_person a
where a.Homelaborlevelname5 = '1000'or
a.Homelaborlevelname5 = '1001' or
a.Homelaborlevelname5 = '1001' or
a.Homelaborlevelname5 = '1010' or

Let's say I have this code. Yet, I have like 20 more values a.HomeLaborlevelname5 can equal to. How can I do something to put it all into one nice statement.

Something like.

where a.Homelaborlevelname5 = ('1000','1001','1002')

How do I do this? I know it's simple, but it's also hard to search for something so simple. Thanks ahead of time.

 

[bborissov]

where a.Homelaborlevelname5 IN ('1000','1001','1002')

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Ray1127]

using sql server TSQL use the following:

Where a.homelaborlevelname5 in ('1000','1001','1002',....)

 

[Jdbenike]

thank you, works beautifully.. good weekend.. giving some thank you clicks now.