select stmt with long list of comparisons ....howto

Hi,
I have a very basic question that I would like resolvein in a more efficient way.

select * from table1 where title = 'director' or title = 'officer' or title='chairman' .....

Is there a more efficient way to do that if I have a long list of comaparisons to do in a select statement. Something like :
select * from table1 where title IN
('director','officer','chairman','accountant');

Thanks all for the help. Received on Sat Apr 14 2001 - 00:04:57 CDT