Board index » delphi » Null value as float in SQL
Sat, 03 Apr 2004 14:12:20 GMT
Null value as float in SQL
I've got a problem with my sql:
SELECT code, sum(amountinc - amountpaid)
This only sums up records where Amountpaid has a figure in it. Any records
How can I get it to pick up null values in the sum calculation so it treats
I've even tried "SELECT code, sum(amountinc - cast(amountpaid as float))"
Using Paradox tables on Win2K box in Delphi 6.
Thanks & Regards