The format for a comparison operator validation check is a string containing one or more comparison operators. Comparison operator validation checks have the following conventional syntax:

The fieldname is the internal name of the field being validated; otherfieldname is the internal name of some other field containing a value to be compared against. In a validation string for a table‑field column, you use tablefieldname instead of fieldname, as follows:

The following table lists valid comparison operators for SQL.