[NEW][SQL] BETWEEN implemented

[Claudius Sailer]

Hi Ruslan,

Am Sonntag, 01.06.03, um 17:44 Uhr (Europe/Berlin) schrieb Ruslan 
Zasukhin:

> It works for everything that you can write as
>
>     WHERE (fld >= a AND fld <= b)
>
> It is inclusive as you see in above line.


AND ZK.AnfangsZeit BETWEEN 01.01."+Jahr+" AND 01.01."+cstr(Jahr.val+1)

AND ZK.AnfangsZeit>=01.01."+Jahr+" AND 
ZK.AnfangsZeit<01.01."+cstr(Jahr.val+1)

with your expanation I expected different results, but I get the same. 
Is it possible the the logic behind between is NOT

WHERE (fld >= a AND fld <= b)

but

WHERE (fld >= a AND fld < b)

my test showed me that the second line would be the correct descipion 
for between.


Ciao


Claudius