From the above (and Gails article) it looks like "in" has the advantage.
I'm not dissenting with any previous replies, but personally I would check the results before changing any production code.
Try it on a test system with the real table structure, indexes, data etc.
Compare the execution plans (actual not estimated) for your setup and see which is the most efficient.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx