Ask Your Question
0

which are the boolean symbols

asked 2018-02-18 18:32:17 +0200

robert leleu gravatar image

I want to select TRUE from a table which include a boolean field. When displayed the field show 3 icons

  1. an empty square
  2. a checked square
  3. a dash in the square

how to select any of these "values" by a SQL "WHERE" condition ?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2018-02-18 19:14:26 +0200

peterwt gravatar image

Empty square indicates FALSE
Tick in square indicates TRUE
Black square inside square indicates NULL

For the WHERE clause use =FALSE, =TRUE, IS NULL

edit flag offensive delete link more
1

answered 2018-02-18 19:12:24 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-02-18 18:32:17 +0200

Seen: 95 times

Last updated: Feb 18 '18