No attachments in this thread
select sum(TotShippingHandling) from Invoice where 1 = 1 andTotShippingHandling <> 0;---
(1 row)
select sum(TotShippingHandling) from Invoice where TotShippingHandling <> 0;sum-------6781.05(1 row)
Red Hat 5.1, intel, PostgreSQL 6.5 (downloaded last night).
Thanks, Michael