[sqlite] Sqlite SUM erroneous return value

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

[sqlite] Sqlite SUM erroneous return value

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