Using Boolean Conditionals in Queries
In the Designer, when you write a query that has a WHERE clause containing a Boolean value, the value must be specified as 1 or 0 instead of true or false.
The following is an example of a WHERE clause that checks for fields where the value of bool_c is true:
WHERE bool_c = 1
The following is an example of a WHERE clause that checks for fields where the value of bool_c is false:
WHERE bool_c = 0
If you use true or false instead, the query does not run.