Progress
Language Reference
LE or < = Operator
Returns a TRUE value if the first of two expressions is less than or equal to the second.
If characters are being compared, the character values are used to index into the current collation table so that the sort value of the characters are used in the comparison.
SYNTAX
expression
A constant, field name, variable name, or expression. The expressions on either side of the LE or < = must be of the same data type, although one can be integer and the other decimal.
EXAMPLEThis procedure lists all the items with zero or negative on-hand quantities.
NOTES
- If either of the expressions is unknown, then the result is unknown; if both of the expressions are unknown, then the result is TRUE.
- You can compare character strings with LE. Most character comparisons are case insensitive in Progress. That is, all characters are converted to uppercase prior to comparisons. However, it is possible to define fields and variables as case sensitive (although it is not advised, unless strict ANSI SQL adherence is required). If either expression is a field or variable defined as case sensitive, the comparison is case sensitive and “Smith” does not equal “smith.”
- Characters are converted to their sort code values for comparison. Using the default collation table, all uppercase letters sort before all lowercase letters (for example, a is greater than Z, but less than b.) Note also that in character code uppercase A is less than [ , \ , ^ , _, and ’ , but lowercase a is greater than these.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |