I'm having a problem with query returning  wrong result.
this is an example: Run this script to create the table and data. use the selct query to test the result.

/* SQL-92 Table Creation Script with DBISAM Extensions */

CREATE TABLE IF NOT EXISTS "Bonus"
(
  "Min_Amount" MONEY,
  "Max_Amount" MONEY,
  "Bonus_Amount" MONEY,
PRIMARY KEY ("RecordID") COMPRESS NONE
);
INSERT INTO "Bonus" VALUES (10, 100, 5);

Select * from bonus where -10 between Min_Amount and Max_amount ;

This query should return an empty dataset but it's returning one row with values (10,100,5).
(-10) is not between 10 and 100.
Please help us understand what's going on..
Thank you,

Halim,

<< I'm having a problem with query returning  wrong result.  this is an
example: Run this script to create the table and data. use the selct query
to test the result. >>

I'm seeing the same thing.  I'll check it out and get a fix in the new build
going out for DBISAM this week.

--
Tim Young
Elevate Software
www.elevatesoft.com