DAO & Logical Fields & Queries

Since this just bit me in the hiney, thought I'd post it.

Using CDaoRecordset against dBase databases if I query based on a logical field, it appears that you need to test against inequality.

Ie
Select * From some.dbf Where (Logical_Field=1); // Fails
Select * From some.dbf Where (Logical_Field=0); // Okay

but

Select * From some.dbf Where (Logical_Field<>0); // Succeeds.