[NEW][SQL] BETWEEN implemented

[Ruslan Zasukhin]

on 6/1/03 18:35, Claudius Sailer at Claudius at sailer-online.de wrote:

Hi Claudius,

> Am Sonntag, 01.06.03 um 17:18 Uhr schrieb Ruslan Zasukhin:
> 
>> Hi guys,
>> 
>> I have implement BETWEEN operator for SQL of 1.x
>> 
>>     WHERE fld BETWEEN a and b
> 
> its possible that standard SQL explains the meaning behind that
> operator, but I don't know. Is this usable with all type. String,
> integer, float, dates etc. and is the between an inclusiv a and
> inclusiv b or both exclusiv?

It works for everything that you can write as

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

It is inclusive as you see in above line.


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