Find operators

You can use the following operators in Find mode. The only operator supported by quick find is double quotation marks (" ").

Operator

Description

=

match whole word (or match empty)

==

match entire field

! find duplicate values
< less than
<= less than or equal to
> greater than
>= greater than or equal to
... range
// today's date
? invalid date or time
@ any one character
# any one digit
* zero or more characters
\ escape next character
"" match phrase (from word start)
*"" match phrase (from anywhere)
~ relaxed search (Japanese only)