Progress
Language Reference
GE or >= Operator
Returns a TRUE value if the first of two expressions is greater than or equal to the second expression.
If characters are being compared, the character values are used to index into the current collation table so that the sort values of the characters are used in the comparison.
SYNTAX
expression
A constant, field name, variable name, or any combination of these. The expressions on either side of the GE or >= must be of the same data type, although one might be integer and the other decimal.
EXAMPLEThis procedure displays item information for those items whose on-hand value is greater than or equal to 120.
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 GE. 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 |