Progress
SQL-89
Guide and Reference
Operators
Operators are the symbols you use to perform calculations and comparisons. SQL operators are the same as Progress operators, except that you cannot use the alternative Progress inequality operators: GT (greater than), LT (less than), or equality operator EQ. Instead, use the standard symbolic operators (>, <, =) for these operations. For detailed information about operators, see the Progress Language Reference.
NOTES
- When you use the arithmetic operators +, -, *, and /, at least one blank space must precede and follow the operator. Omitting the spaces results in an error message.
- If you start Progress with an ANSI SQL startup parameter (-Q or -Q2) and then divide by zero, the offending Progress/SQL expression returns the UNKNOWN value and raises an SQL data exception.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |