>>Naomi, I question the judgment of this for anything more than a few items.
>Joining against a temp table/table variable/subquery/etc is the way to go.
>
>IIRC In () gets expanded into a cursor in vfp already,
>so I surmise that SQL server and others in this league implement it such as well.
>Under this assumption, the In() way of coding is probably the easiest and most
>portable way to code for things like a filter with a user-defined ad-hoc list of items.
>
>my 0.02 EUR
>
>thomas
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.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"