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.