Table of contents
No headers Comparison operators
| Summary | Comparisons used to express relationships (e.g. greater than, equal to) between values. |
| Maintainer | Information Technology |
| Source | Information Technology |
| Affects | Various forms and reports that evaluate information based on conditional relationships |
| Affected By |
|
| Values | SQL is a printf-style string with placeholders (%s) for the left- and right-hand sides of the comparison, or multiple values in the case of more complex expressions. |
| Requirements |
|
| Operation | The order of the values supplied for the SQL string is the same for all expressions; the left-hand side is always the database value being tested, the right-hand side is what the database value is being compared with. For expressions that evaluate a range (e.g. BETWEEN) a lower and upper bound are expected. Sets of values can also be used, and are generally constructed from a comma-separated list of values. |
