TWhereOperator Enumeration
Specifies the comparison operator used in a SQL WHERE predicate.
Syntax
Unit: Aurelius.Sql.BaseTypes
Members
| Name | Value | Description |
|---|---|---|
| woEqual | 0 | Tests equality: field = value. |
| woDifferent | 1 | Tests inequality: field <> value. |
| woGreater | 2 | Tests greater-than: field > value. |
| woLess | 3 | Tests less-than: field < value. |
| woGreaterOrEqual | 4 | Tests greater-than-or-equal: field >= value. |
| woLessOrEqual | 5 | Tests less-than-or-equal: field <= value. |
| woLike | 6 | Tests pattern matching: field LIKE value (case-sensitive). |
| woIsNull | 7 | Tests for a NULL value: field IS NULL. |
| woIsNotNull | 8 | Tests for a non-NULL value: field IS NOT NULL. |
| woIn | 9 | Tests membership in a list: field IN (...). |
| woILike | 10 | Tests case-insensitive pattern matching: field ILIKE value (on databases that support it). |