Hi, I have a field in sqlite database declared as BOOLEAN, and also set it's value with Dataset.FieldByName('bool_field').AsBoolean. If I view the table in SQLite Spy then values show up as true or false. How do I construct a sql statement to search on such a boolean value, e.g: select * from table where bool_field = TRUE. I've tried a few options but none have worked so far :/ Thanks Rael