Greetings All,

I have the following query:

select * from testtbl
where
f_fixedpoint(amt,2) = 0

The table only has 1 record in it with the structure:
CREATE TABLE TESTTBL (
ID DOM_ID NOT NULL,
FLD1 VARCHAR(10) CHARACTER SET NONE,
COS VARCHAR(200) CHARACTER SET NONE,
AMT MONEY,
CONSTRAINT PK_TESTTBL PRIMARY KEY (ID);

domain dom_id is simply:
CREATE DOMAIN DOM_ID AS INTEGER
NOT NULL;
domain money is defined as:
CREATE DOMAIN MONEY AS
DOUBLE PRECISION
DEFAULT 0

The only record in it has a value of 1 for ID and -.36 in AMT.

Problem:
Running the query against IB 5.6 I get no records (which is correct!)
Running the query against IB 6.01 the 1 record is returned!!!

Thus, one of my posting procedures in the accounting application is now out
of balance!

Comments or clues anyone??

Thanks in Advance,
Kevin