select SaleID, sum(SettleAmount) as Summed from Sale group by SaleID 
having Summed is not null

---

 Comments and Workarounds

---

The workaround is to use = NULL or <> NULL instead.

---

 Resolution

---

Fixed Problem on 1/2/2008 in version 4.26 build 1

---

 Products Affected

---

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial