# Compare

> Checks if the first field or expression value is equal to the second value.

## Equal to (=)

### Description

Checks if the first field or expression value is equal to the second value.

* Returns `true` if the field or expression values are equal.
* Returns `false` if the values are not equal.

### Syntax

`<Comparison field or Expression> = <Comparison field or Expression>`

### Supported values

All values can be used. Both values must be of the same kind.

### NULL handling

If you use an **Equal to (=)** comparison with `NULL`, the result is always `NULL` or unknown, not `true` or `false`.

### Example

`Actual date = Expected date`

## Greater than or equal to (&gt;=)

### Description

Checks if the first field or expression value is equal to or greater than the second value.

* Returns `true` if the first field or expression value is greater than or equal to the second value.
* Returns `false` if the first value is less than the second value.

### Syntax

`<Comparison field or Expression> >= <Comparison field or Expression>`

### Supported values

All values can be used. Both values must be of the same kind.

### NULL handling

If you use an **Greater than or equal to (&gt;=)** comparison with `NULL`, the result is always `NULL` or unknown, not `true` or `false`.

### Example

`Actual date >= Expected date`

## Greater than (&gt;)

### Description

Checks if the first value is greater than the second value.

1. Returns `true` if the first field or expression value is greater than the second value.
2. Returns `false` if the first value is equal to or less than the second value.

### Syntax

`<Comparison field or Expression> > <Comparison field or Expression>`

### Supported values

All values can be used. Both values must be of the same kind.

### NULL handling

If you use an **Greater than (&gt;)** comparison with `NULL`, the result is always `NULL` or unknown, not `true` or `false`.

### Example

`Actual date > Expected date`

## Less than or equal to (&lt;=)

### Description

Checks if the first field or expression value is equal to or less than the second value.

* Returns `true` if the first field or expression value is less than or equal to the second value.
* Returns `false` if the first value is greater than the second value.

### Syntax

`<Comparison field or Expression> <= <Comparison field or Expression>`

### Supported values

All values can be used. Both values must be of the same kind.

### NULL handling

If you use an **Less than or equal to (&lt;=)** comparison with `NULL`, the result is always `NULL` or unknown, not `true` or `false`.

### Example

`Actual date <= Expected date`

## Less than (&lt;)

### Description

Checks if the first field or expression value is less than the second value.

* Returns `true` if the first field or expression value is less than the second value.
* Returns `false` if the first value is equal to or greater than the second value.

### Syntax

`<Comparison field or Expression> < <Comparison field or Expression>`

### Supported values

All values can be used. Both values must be of the same kind.

### NULL handling

If you use an **Less than or equal to (&lt;=)** comparison with `NULL`, the result is always `NULL` or unknown, not `true` or `false`.

### Example

`Actual date < Expected date`

## Not equal to (!=)

Checks if the first field or expression value is not equal to the second value.

* Returns `true` if the values are not equal.
* Returns `false` if the first value is equal to the second value.

### Syntax

`<Comparison field or Expression> != <Comparison field or Expression>`

### Supported values

All values can be used. Both values must be of the same kind.

### NULL handling

If you use an Not e**qual to (!=)** comparison with `NULL`, the result is always `NULL` or unknown, not `true` or `false`.

### Example

`Actual date != Expected date`

## `IN`

### Description

Checks if the first field or expression value matches one of the values in a specified list.

* Returns `true` if the field or expression value matches either one of the expression, field, or contant values specified in a list values.
* Returns `false` if the field or expression value matches none of the specified values.

### Syntax

`<Field or Expression> IN <Expression or Field or Constant> [+<Expression or Field or Constant> + ...]`

### Supported values

All values can be used. Values must be of the same kind.

### NULL handling

If the first input field or expression is `NULL`, the result is `NULL`. `NULL` values in the list of values are not taken into account.

### Example

`Activity IN ("Create purchase order", "Create purchase order item"`

## `IS NULL`

### Description

Checks if a field or expression value is `NULL`.

* Returns `true` if the field or expression value is `NULL`.
* Returns `false` if the value is not `NULL`.

### Syntax

`<Field or Expression> IS NULL`

### Supported values

All values can be used.

### NULL handling

N/A

### Example

`Automated IS NULL`

## `IS NOT NULL`

### Description

Checks if a field or expression value is not `NULL`.

1. Returns `true` if the field or expression value is not `NULL`.
2. Returns `false` if the value of is `NULL`.

### Syntax

`<Field or Expression> IS NOT NULL`

### Supported values

All values can be used.

### NULL handling

N/A

### Example

`Automated IS NOT NULL`