Options for numeric searches

Build 1501 on 14/Nov/2017  This topic last edited on: 19/Oct/2016, at 14:06

Numeric fields have the options, listed in the following table.

Wildcard characters, e.g. * or ?, are not allowed.

Option

Matches the records which in the chosen field contain

any

any number

<

a number smaller than the specified number.

<=

a number smaller than or equal to the specified number.

>

a number greater than the specified number.

>=

a number greater than or equal to the specified number.

=

a number equal to the specified number.

!=

a number different than the specified number.

between

a number greater than the number, specified in the first field, and less than the number, specified in the second field.