The logical operator NOT is supported for use in conditional expressions, connecting either comparison operators or logical predicates. When dragging a Not operator into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Logical > Not
Columns and/or other expressions can be moved into the (empty) branch of the tree.
There are no special properties for the Not operator.