Skip to main content

Compare

Syntax​

Compare             field_name

Parameters​

ParameterDescription
field_nameThe name of the field to compare

Description​

Works like Select but compares two fields against each other rather than comparing a field to a fixed value. Use comparison operators (EQ, NE, GT, LT, GE, LE) with a second field name to filter records where the relationship holds.

Remarks​

  • The comparison operator line following Compare takes a second field name instead of a literal value.
  • Useful for finding records where two fields have the same (or different) values.
  • Supports the same comparison operators as Select.

Examples​

Find participants whose AGE field matches their AGE1 field:

Compare             AGE
EQ                  AGE1

Find participants whose Gun time is greater than their Net time by comparing fields:

Compare             GunTime
GT                  NetTime