...
| Excerpt |
|---|
|
Functions which compare values and return a true or false result. |
List of logical functions
The following logical functions are available:
...
Some logical functions may take a Comparator Type parameter which specifies the comparison operations. These are strings with one of the following values:
| Comparator | Meaning | Types handled |
|---|
| _LESS_THAN | The first item is less than the second. |
Numerical and Alphabetic comparisons are handled| | numeric, alphabetic |
| _GREATER_THAN | The first item is greater than the second. |
Numerical and Alphabetic comparisons are handled| | numeric, alphabetic |
| _EQUALS | The first item is identical to the second. |
Numerical and Alphabetic comparisons are handled| | numeric, alphabetic |
| _GREATER_THAN_OR_EQUAL | The first item is identical to or greater than the second. |
Numerical and Alphabetic comparisons are handled| | numeric, alphabetic |
| _LESS_THAN_OR_EQUAL | The first item is identical to or less than the second. |
Numerical and Alphabetic comparisons are handled| | numeric, alphabetic |
| _NOT_EQUALS | The first item is not identical to the second. |
Numerical and Alphabetic comparisons are handled| | numeric, alphabetic |
| _STARTS_WITH | The first item starts with the second string. |
Alphabetic comparisons only | alphabetic |
| _NOT_STARTS_WITH | The first item does not start with the second string. |
Alphabetic comparisons only | alphabetic |
| _LIKE | The first item is like the second string. |
Alphabetic comparisons only| | alphabetic |
| _IS_NOT_NULL | The first item is not null compared to the second string ?? | numeric, alphabetic |
| _IS_NULL | The first item is null to the second string ?? | numeric, alphabetic |
Clarifying info required:
- If you use a comparator are you asking a question? Is A (comparison) B?
- Syntax of a simple example, e.g. A _EQUALS B
- What do you get back Returns either 1 or 0 to indicate true or false
- If you use a comparator are you asking a question? What do you get back
- Is A less than B
- _START: how many characters ???
- How does _LIKE work???
- ISNULL - what is it comparing