>I'm not sure what sqlserver's limit is, but I know it will throw a resource error if the list is too long. I know the last version of Oracle I worked with had a limit of 1000 items in a SQL IN list.

Quite similar to Fabio's finding (unless Oracle can also be twitched a bit).
Should be enogh even for some pages of "mark all" GUI-Selected items,
which can be sent over wothout creating a serverside temp table first.

regards

thomas