When you have more than 7 or 8 such agents, the better way would be to insert into them into a table and use that table to either left join or sub query with in clause based on the need.