>I expect SQL server to execute it this way - at least for longer list len, perhaps switching strategies depending in the list given in the SQL.
>Update: on reading Naomi's link I may have overestimated SQL optimizer capabilities, but basic gut instinct was correct ;-)

Thanks for the additional input