> There are many times that the database developer can't predict (it's
> dependent on the user) an interval of records that your statement will act.

> Example:
> select * form t where id in (1, 5, ...)
> or
> select * from t where id between 5 and 10 or id between 20 and 30 or
> id = 50

Hi,

I will be prefer only extended syntax for IN operator not new operator like:

SELECT * FROM table WHERE id IN(0..3,4,6..9)

I was copy this from pascal case :).

Slavek

Ing. Slavomir Skopalik
Jednatel spolecnosti
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
--------------------------------------------
Mobil: +420 724 207 851
icq:199 118 333
e-mail:skopalik@...
http://www.elektlabs.cz <http://www.elektlabs.cz/>




.

<http://geo.yahoo.com/serv?s=97359714/grpId=464142/grpspId=1705007183/msgId=9435
/stime=1165110702>




[Non-text portions of this message have been removed]