---
schema_version: "1"
id: 3deab16cb123ad28099fb8b07c997e5c219faf55b5c91475cd78d9bae42dda8a
title: Logical Operators
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/logical.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/logical.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: efd76560ea672c1f80bf44394e8cc9d612ce9cda9178763d137f9e9b3e513e2e
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# Logical Operators

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

These are the logical operators for boolean values:`AND`, `OR`, `NOT`. SQL uses a three-valued logic system with true, false, and `null`, which represents “unknown”.

| `a`   | `b`   | `a AND b` | `a OR b` |
| :---- | :---- | :-------- | :------- |
| TRUE  | TRUE  | TRUE      | TRUE     |
| TRUE  | FALSE | FALSE     | TRUE     |
| TRUE  | NULL  | NULL      | TRUE     |
| FALSE | FALSE | FALSE     | FALSE    |
| FALSE | NULL  | FALSE     | NULL     |
| NULL  | NULL  | NULL      | NULL     |

| `a`   | `NOT a` |
| :---- | :------ |
| TRUE  | FALSE   |
| FALSE | TRUE    |
| NULL  | NULL    |

The operators `AND` and `OR` are commutative, that is, you can switch the left and right operand without affecting the result.