Hi,

>>just to queries like this:
>>
>> select p.name from phones p where p.extension in
>> (0000, 0001, 0002, 0003, 0004, 0005, 0006, 0007,.... 1499)
>>
>>The restriction may be lifted in V2, I don't remember.
>
>
> No, it isn't changed.
>
> btw as workaround you can split the IN part in multiple IN predicates combined by the OR operator.
>
> select p.name from phones p where
> p.extension IN (0000, 0001, 0002, 0003, ...1499) OR
> p.extension IN (1500, 1501, 1502, 1503, ...2999) ...

I would have suggested a plain series of OR conjuctions, but then the
max. statement size might hit today, tomorrow or next week. So, I like
yours better. Neat workaround. ;-)



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com