...i don't think it matters which way you do it.

IN clauses are fairly efficient if the column is indexed. Must admit that I've never heard of the 500 limit on the items. Just tried an IN clause with 1028 entries and it worked fine. Think your DBA is thinking of 6.5 days.