How do I compare Yes/No types in SQL?
Confirmed version of the operation
Verify Access Version
Check the Windows version
- XP SP2 and later
select * from テーブル where 表示フラグ = true
Compare with "true, false" as follows: In other SQL types, there are types such as bit and boolean instead of Yes/No types, which may be compared with "1, 0" instead of "true, false". By the way, it is not possible to compare by "1, 0" in Access.