select * from table1 where eid in ('100','101','102');
Would get you all the info from 100, 101 and 102 (and however many others you named specifically)
or
select * from table1 where eid like '10%';
Would get you all the info from 10, 100-109 and 1000 - 1099
Matt G.
Power tools, air tools, cordless power tools - ToolBarn.com