Access

How do I compare Yes/No types in SQL?

Page creation date :

Confirmed version of the operation

Verify Access Version

  • 2003

Check the Windows version

  • XP SP2 and later

Tips (a.m.)

t:System.Type to compare Yes/No types in Access;

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.

How do I compare dates in SQL?