​
<expression> != <value>

​
Description

Implements the NOT EQUAL TO operator. <expression> can be <table>.<column> or AGG(<table>.<column>, <start>, <end>). This operator can be applied to columns of all types. The constant data type needs to match the aggregation/column data type.

​
Example

LAST(LOAN.AMOUNT, 0, 30) != 0