Conditional Operators Reference |
Conditional operators are used in conditional statements to determine the relationship that you want to establish between a data source and a specified value. Conditional statements are structured just like a sentence, with a subject (the data source), a verb (the operator), and an object (the value). You can use conditional operators to do the following:
The following table describes the valid data types that can be used with each conditional operator.
|
|
The conditional operators that are available can depend on the feature for which you are creating the conditional statement. They can also depend on the type of database that is connected to the document. For information about how to view the available conditional operators for your statement, refer to the documentation for the specific dialog or property page that you are using to create the conditional statement. |
|
|
Conditional operator |
Valid inputs |
Example |
|---|---|---|---|
|
|
Equals |
All types except Time, Binary, and Picture |
[data source] Equals <value> |
|
|
Does not equal |
All types except Time, Binary, and Picture |
[data source] Does Not Equal <value> |
|
|
Is greater than |
All types except Time, Binary, and Picture |
[data source] Is greater than <value> |
|
|
Is greater than or equal to |
All types except Time, Binary, and Picture |
[data source] Is greater than or equal to <value> |
|
|
Is less than |
All types except Time, Binary, and Picture |
[data source] Is less than <value> |
|
|
Is less than or equal to |
All types except Time, Binary, and Picture |
[data source] Is less than or equal to <value> |
|
|
Is between |
All types except Time, Binary, and Picture |
[data source] Is between <value 1> and <value 2> |
|
|
Is not between |
All types except Time, Binary, and Picture |
[data source] Is not between <value 1> and <value 2> |
|
|
Contains |
Text only |
[data source] Contains <value> |
|
|
Does not contain |
Text only |
[data source] Does not contain <value> |
|
|
Begins with |
Text only |
[data source] Begins with <value> |
|
|
Ends with |
Text only |
[data source] Ends with <value> |
|
|
Is like |
Text only |
[data source] Is like <value> |
|
|
Is not like |
Text only |
[data source] Is not like <value> |
|
|
Is Null |
SQL only |
[data source] Is Null |
|
|
Is Not Null |
SQL only |
[data source] Is Not Null |
|
|
Is Empty |
Text only |
[data source] Is Empty |
|
|
Is Not Empty |
Text only |
[data source] Is Not Empty |
|
|
Is blank |
All data types |
[data source] Is blank |
|
|
Is not blank |
All data types |
[data source] Is not blank |
|
|
Is any of |
All types except Time, Binary, and Picture |
[data source] Is any of <value 1>, <value 2>, <value 3>... |
|
|
Is none of |
All types except Time, Binary, and Picture |
[data source] Is none of <value 1>, <value 2>, <value 3>... |
|
|
Is beyond this year |
Dates only |
[data source] Is beyond this year |
|
|
Is later this year |
Dates only |
[data source] Is later this year |
|
|
Is later this month |
Dates only |
[data source] Is later this month |
|
|
Is next week |
Dates only |
[data source] Is next week |
|
|
Is later this week |
Dates only |
[data source] Is later this week |
|
|
Is tomorrow |
Dates only |
[data source] Is tomorrow |
|
|
Is today |
Dates only |
[data source] Is today |
|
|
Is yesterday |
Dates only |
[data source] Is yesterday |
|
|
Is earlier this week |
Dates only |
[data source] Is earlier this week |
|
|
Is last week |
Dates only |
[data source] Is last week |
|
|
Is earlier this month |
Dates only |
[data source] Is earlier this month |
|
|
Is earlier this year |
Dates only |
[data source] Is earlier this year |
|
|
Is prior this year |
Dates only |
[data source] Is prior this year |
Related Topics
