Yes, you use an IN statement for that

select * from Table2 where eid in ('123','124','125')

I think you mentioned an IP address could be the eid? If that is the case and these are the first 3 digits of each IP Address you are looking to match up you would have to only look at the first 3 characters of the "eid" and then compair it to the list given.

select * from Table2 where left(eid,3) in ('123','124','125')

__________________
MArms
self-help book | used cell phones | cell phone donation