Table 34. DAC Query Commands and Operators
|
|
= |
Placed before a value, returns records containing a value equal to the query value. |
< |
Placed before a value, returns records containing a value less than the query value. |
> |
Placed before a value, returns records containing a value greater than the query value. |
<> |
Placed before a value, returns records containing a value that is not equal to the query value. |
<= |
Placed before a value, returns records containing a value less than or equal to the query value. |
>= |
Placed before a value, returns records containing a value greater than or equal to the query value. |
* |
Wildcard that can be placed in the middle, or at the beginning or end of a text string. |
! |
Used for negation. |
"" |
Surrounds a string that, unless modified by a wildcard, must be matched exactly. |
\ |
Escape symbol is used when double quotes should not be processed as a special symbol. For example, !("*null text"or(\"*\")) is a value expression for a text field. The query returns values that do not end with a string null text and that are not surrounded by double quotes. |
() |
Surrounds the values and operators that will be processed first. |
NULL |
Returns records for which the query field is blank. |
AND |
Placed between values, returns only records for which all the given conditions are true. (Not case sensitive.) |
OR |
Placed between values, returns records for which at least one condition is true. (Not case sensitive.) |