Null Handling

Below is a table that demonstrates how Nulls are handled in Designer as of version 5.0 and later. The same handling applies to numbers and strings.

Data 1 Data 2 Data1 > Data2 Data1 < Data2 Data1 == Data2 Data1 != Data2
1 [Null] False False False True
0 [Null] False False False True
[Null] [Null] False False True False

If a number is added to Null the result is Null.

1 + Null() == Null()

If a String is added to Null, the result is the String.

[ABC123] + Null() == ABC123

Nothing is greater or less Null(). If there is a Null() on either side of a < or >, the answer is False.

Null() < Null() == False

When using <= or >=, if there is a Null() on either side, the only way the comparison equals True is if there is a Null() on the other side because Null() == Null().