[NEW][SQL] BETWEEN implemented

[Ruslan Zasukhin]

on 6/21/03 13:06, Claudius Sailer at Claudius at sailer-online.de wrote:

Hi Claudius,

> 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.

May be this is your data joke with you?

Try simplest table with 1 2 3 4 5 values in records
And do BETWEEN 2 and 4

What results?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------