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) |