At 06:31 PM 07-11-02 -0500, Sean Leyne wrote:

>Mark and Svein,
>
> > From: Mark Patterson [mailto:mpatterson@...]
>
>
> >
> > WHERE KeyNum IN (10, 13..20, 22.35, 41, 43)
> >
> > Nothing like succinctness! But it must be an MS SQL
> > extension. I hope it gets included in the next SQL
> > standard.

I don't! I think it's a very short-sighted feature and I'd much prefer for
it to stay as now, viz.

where something IN (set of individual values of the same size and type)

The enhancement I would love to see is the ability to parameterise the
items inside the comparison set. I have difficulty seeing how this could
be done if it were allowable to include a set as a comparison value.

I can do this already:

where something IN (10.00, 22.35, 41.00, 43.00)
or something BETWEEN 13.00 and 20.00

but how often have I wanted to pass values for a set to a SP, so that my SP
could have

where something IN (arg1, arg2, arg3, arg4)

iow, I don't think you get much bang for your buck being able to include a
set as if it were a comparison value...especially if it would preclude
adding a much more powerful enhancement.

heLen