# Where

{% hint style="info" %}
The `WHERE` keyword filters a list or concept set.

This function is SQL compatible. For more information about SQL compatibility, see our [documentation](https://docs.wem.io/platform/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
Returns a filtered list or concept set.
{% endhint %}

<details>

<summary><mark style="color:blue;"><code>list</code></mark><code> where </code><mark style="color:blue;"><code>condition</code></mark></summary>

`[Products.Name] of [Products] WHERE [Products.Price] > 100`\
\&#xNAN;*=> the names of all products that have a price higher than 100.*

</details>

<details>

<summary><mark style="color:blue;"><code>concept_set</code></mark><code> where </code><mark style="color:blue;"><code>condition</code></mark></summary>

`GetChildren('Color') WHERE concept:'PrimaryColor' = true`\
\&#xNAN;*=> all color concepts from the Color collection that have the PrimaryColor property set to true.*

</details>