Svein Erling Tysvaer wrote:

> At 16:31 07.11.2002 +1000, you wrote:
>
>>WHERE KeyNum in (100..150)
>
>
> Don't know, I've never tried it nor seen any need for it. I always use
> WHERE KeyNum BETWEEN 100 AND 150

I was using it in MS SQL Server to produce lists of any complexity, so the
ability to mingle ".." and "," in the IN clause was great. I was generating the
IN argument from another query, and it would come out like this little number I
just made up, or much longer:

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.

Regards,

Mark