S/O Range

This must be specified if the Select/Omit Type is Range.

Range From

Mandatory.

Specify the lower value that the select/omit column should be compared to.

Rules

Allowable values are:

• Character literal in quotes (e.g. 'BALMAIN').

• Numeric literal (e.g.  1.54).

• DateTime literal in quotes. (e.g. '2005-05-01 10:00:00')
  DateTime literals need to be entered as per the SUTC attribute of the field.
  If the SUTC attribute is enabled, enter the value as UTC, otherwise enter the value in local time.

• Name of another column in the table definition.

S/O Range To

Mandatory.

Rules

Allowable values are:

• Character literal in quotes (e.g. 'BALMAIN').

• Numeric literal (e.g.  1.54).

• DateTime literal in quotes. (e.g. '2005-05-01 10:00:00')
  DateTime literals need to be entered as per the SUTC attribute of the field.
  If the SUTC attribute is enabled, enter the value as UTC., otherwise enter the value in local time.

• Name of another column in the table definition.