Search on number and money fields

You can use search operators to search on number and money fields.

Search operators

Type of search Operator Format Example
Ranges … Three dots between numbers.

3...20

This example will find numbers between 3 and 20.

Greater than > Right angle bracket before a number.

>1000

This example will find numbers from 1001 to the highest number in the index.

Lesser than < Left angle bracket before a number.

<1000

This example will find numbers from 1 to 999.

Anything except this number # Hash symbol before a number.

#3

This example will find any number except 3.