Compare to value

Mandatory.

Specify the column/literal that will make up the value which is being compared with the Column Name.

The values are checked for type and length compatibility with the Column Name.

If the operation codes are suffixed by a "P", the condition must not be a literal.

Rules

Allowable values are:

• An alphanumeric literal such as 'NSW', NSW, 'Balmain' or BALMAIN

• A numeric literal such as 1, 14.23, -1.141217.

• Another column name such as #CUSTNO, #INVNUM, etc.

• A system variable name such as *BLANKS, *ZERO, *DATE or any other system variable defined at your installation.