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)