Sent from my BlackBerry® wireless device
-Original Message-
From: Van Ry, Wayne [EMAIL PROTECTED]
Date: Wed, 4 Jun 2008 14:17:33
To:[EMAIL PROTECTED]
Subject: FW: Sqlite SUM erroneous return value
__
From: Van Ry, Wayne
Hi,
I have created a table with the following values.
CREATE TABLE [test] ([Id] TEXT DEFAULT(0), [PV] REAL DEFAULT(0));
insert into [test] (Id, PV) values ('485314EL', '-720.237');
insert into [test] (Id, PV) values ('485314L', '-720.237');
insert into [test] (Id, PV) values ('485314LE',