Progress
Language Reference
LT or < Operator
Returns a TRUE value if the first of two expressions is less than the second.
SYNTAX
expression
A constant, field name, variable name, or expression. The expressions on either side of the LT or < = must be of the same data type, although one can be an integer and the other can be a decimal.
EXAMPLEThis procedure displays information for those item records whose on-hand value is less than the allocated value.
NOTES
- If either of the expressions is unknown, then the result is unknown; if both of the expressions are unknown, then the result is FALSE.
- You can compare character strings with LT. 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 |