# 289 SQL SELECT Statement with WHERE Clause Comparing Boolean Field Returns Incorrect Records

---

In my project the query returns no records. In DBSYS, the same query returns two records (which is correct).

Follow-up:

I got it. In the project I sent you, if you drop the index on PPD in hearings.dat, the queries work OK. Something about the index causes the query to fail in Delphi, but to succeed in DBSYS.