Progress
SQL-92
Guide and Reference
GREATEST Function
Returns the greatest value among the values of the given expressions.
SYNTAX
EXAMPLE
This example illustrates the GREATEST function:
NOTES
- The first argument to the function can be of any type. However, the types of the subsequent arguments must be compatible with that of the first argument.
- The type of the result is the same as that of the first argument.
- If any of the argument expressions evaluate to null, the result is null.
- When the data type of an
expression
is either CHARACTER(length
) or VARCHAR(length
), the expression may contain multi-byte characters. The sort weight for each character is determined by the collation table in the database.COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |