I want to select TRUE from a table which include a boolean field.
When displayed the field show 3 icons
- an empty square
- a checked square
- a dash in the square
how to select any of these “values” by a SQL “WHERE” condition ?
Hello,
The three icons are a tristate setting - TRUE, FALSE or undefined. The WHERE conditions:
-
WHERE “YOUR_FIELD” = ‘TRUE’
this is checked square -
WHERE “YOUR_FIELD” = ‘FALSE’
this is empty square -
WHERE “YOUR_FIELD” IS NULL
this is dash in square
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.
Empty square indicates FALSE
Tick in square indicates TRUE
Black square inside square indicates NULL
For the WHERE clause use =FALSE, =TRUE, IS NULL