---
schema_version: "1"
id: 779eaf8a3ccefe077a9f6a4b534c1216a948ac3fc35044ef68d428f3a7dd6847
title: Boolean Expressions in SELECT Clause
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-boolean.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-boolean.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: af0c2d8a5d890b085827eef9c346a3afbd8148eae69b974f08aae1008d408a69
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# Boolean Expressions in SELECT Clause

A boolean expression is a logical statement that returns either `true` or `false`.

A boolean expression in `SELECT` follows this syntax: `SELECT {boolean_expression} as {alias}`.

This example demonstrates a query that satisfies one numerical logical condition.

```nolang
SELECT Profit > 0 as Profits FROM "Superstore" LIMIT 5;

```

| Profits |
| ------- |
| true    |
| true    |
| true    |
| false   |
| true    |

This example demonstrates a query that satisfies two numerical logical conditions.

```nolang
SELECT Profit > 0 and Profit < 100 as Profits FROM "Superstore" LIMIT 5;
```

| Profits |
| ------- |
| true    |
| false   |
| true    |
| false   |
| true    |

This example demonstrates a text comparison.

```nolang
SELECT Customer_Name LIKE 'A%' as "A Names" FROM "Superstore" LIMIT 5;
```

| A Names |
| ------- |
| false   |
| false   |
| false   |
| false   |
| true    |