# NQL comparison operators

Use comparison operators with [nql-where](https://docs.nexthink.com/platform/understanding-key-data-platform-concepts/nexthink-query-language-nql/nql-keywords/nql-where "mention") clause to filter your NQL query results.

<table><thead><tr><th width="127.54541015625">Operator</th><th width="154.72723388671875">Definition</th><th width="185.3636474609375">Supported data types</th><th>Examples</th></tr></thead><tbody><tr><td><code>==</code> or <code>=</code></td><td>Equals</td><td><p>string</p><p>int</p><p>float</p><p>Boolean</p><p>date time</p><p>enumeration</p><p>duration</p><p>IP address</p><p>version</p></td><td><p><code>| where user.name = "jdoe@kanopy"</code></p><p><code>| where user.name == "jdoe@kanopy"</code></p></td></tr><tr><td><code>!=</code></td><td>Not equals</td><td><p>string</p><p>int</p><p>float</p><p>Boolean</p><p>date time</p><p>enumeration</p><p>duration</p><p>IP address</p><p>version</p></td><td><code>| where hardware_manufacturer != "VMWare"</code><br><code>| where hardware_manufacturer != null</code></td></tr><tr><td><code>></code></td><td>Greater than</td><td><p>int</p><p>float</p><p>duration</p><p>byte</p><p>IP address</p><p>version</p></td><td><code>| where hardware.memory > 8GB</code></td></tr><tr><td><code>&#x3C;</code></td><td>Less than</td><td><p>int</p><p>float</p><p>duration</p><p>byte</p><p>IP address</p><p>version</p></td><td><code>| where hardware.memory &#x3C; 16GB</code></td></tr><tr><td><code>>=</code></td><td>Greater or equal</td><td><p>int</p><p>float</p><p>date time</p><p>duration</p><p>byte</p><p>IP address</p><p>version</p></td><td><code>| where hardware.memory >= 8GB</code></td></tr><tr><td><code>&#x3C;=</code></td><td>Less or equal</td><td><p>int</p><p>float</p><p>date time</p><p>duration</p><p>byte</p><p>IP address</p><p>version</p></td><td><code>| where hardware.memory &#x3C;= 16GB</code></td></tr></tbody></table>

Refer to [nql-data-types](https://docs.nexthink.com/platform/understanding-key-data-platform-concepts/nexthink-query-language-nql/nql-syntax-overview/nql-data-types "mention") for more information.

{% hint style="info" %}
In comparison operations, `=` and `==` are interchangeable. However, when used for aliasing in [nql-compute](https://docs.nexthink.com/platform/understanding-key-data-platform-concepts/nexthink-query-language-nql/nql-keywords/nql-compute "mention") or [nql-summarize](https://docs.nexthink.com/platform/understanding-key-data-platform-concepts/nexthink-query-language-nql/nql-keywords/nql-summarize "mention") statements, only the single `=` is supported.
{% endhint %}

All expressions used in combination with these operators are case-insensitive. For example, the following queries return the same results:

{% code overflow="wrap" lineNumbers="true" %}

```
devices during past 24h
| where name == "CORPSYS2022"
```

{% endcode %}

{% code overflow="wrap" lineNumbers="true" %}

```
devices during past 24h
| where name == "CoRpSyS2022"
```

{% endcode %}

### Using wildcards

Use wildcards to match partial values and increase filter flexibility. Expressions used in combination with comparison operators support the following wildcard characters.

<table><thead><tr><th width="109">Operator</th><th width="189.36358642578125">Definition</th><th>Examples</th></tr></thead><tbody><tr><td>*</td><td>Replaces any number of characters</td><td><p><code>| where application.name = "Microsoft*"</code></p><p>Returns application names starting with "Microsoft"</p><p><code>| where application.name = "*Microsoft*"</code></p><p>Returns application names containing "Microsoft"</p></td></tr><tr><td>?</td><td>Replaces any single character</td><td><p><code>| where device.operating_system.name == "Windows 1?"</code></p><p>Returns operating system names with versions above 10, such as Windows 10 and Windows 11.</p></td></tr><tr><td>...</td><td></td><td></td></tr></tbody></table>