Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 755
Upper
Description Converts all characters in a string to uppercase letters.
Syntax Upper ( string )
Return value
String. Returns string with lowercase letters changed to uppercase if it
succeeds and the empty string (“”) if an error occurs.
Examples This expression returns BABE RUTH:
Upper("Babe Ruth")
See also
Lower
Var
Description Calculates an estimate of the variance for the specified column. The variance
is the square of the standard deviation.
Syntax Var ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
Argument Description
string The string you want to convert to uppercase letters
Argument Description
column The column for which you want an estimate for the variance of the
values in the rows. Column can be the column name or the column
number preceded by a pound sign (#). Column can also be an
expression that includes a reference to the column. The datatype of
column must be numeric.