>It seems that "BETWEEN" in SQLite is treated as "BETWEEN..AND selects >fields that are between and including the test values", so it can be >used instead of ">=" and "<=". I am sorry, but it seems I am partially correct. I tested again and concluded:
1. "BETWEEN" in SQLite is treated as "BETWEEN..AND selects fields that are between and including the test values", so it can be used instead of ">=" and "<=", ONLY if you specify COMPLETE test values, example "20071001" AND "20071131". 2. If you specify PARTIAL test values, example "200710" AND "200711", then "BETWEEN" in SQLite is treated as "BETWEEN..AND selects fields between the test values, including the first test value and excluding the last test value". 3. It is not reliable to use "BETWEEN" for now (and not only in SQLite, but also in other DBMS), better use >= and <=. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
