Mark and Svein,

> From: Mark Patterson [mailto:mpatterson@...]

> Svein Erling Tysvaer wrote:
> > At 16:31 07.11.2002 +1000, you wrote:
> >
> >>WHERE KeyNum in (100..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.

I have forwarded this message to the Firebird Devel list for further
discussion/comment and will be adding this to the Firebird Feature
Request list.


--
Sean Leyne

There is nothing wrong with Interbase,
that can't be fixed with Firebird.
http://FirebirdSQL.org