This section gives a quick lookup table for each category of operators and functions. The categories are arithmetical, character, date, logical, multi-occurrence and time.
Operands and parameters may have the following datatypes:
|
Data Type |
Description |
|
C |
Mixed case character (ASCII collate) |
|
D |
Date |
|
I |
16-bit integer (range -32K to 32K) |
|
L |
32-bit integer |
|
M |
Mixed case character (Database collate) |
|
N |
Number (for very large or non integer numbers) |
|
P |
Pseudo-numeric (Digit only character fields) |
|
T |
Time |
|
U |
Upper case character with Database collate |
|
Y |
Boolean (Yes/No) |
To simplify the lookup tables note the following:
where N is indicated, I and L may be used
where C is indicated, M, P and U may be used
The following categories are covered: