UPPER: Returning a String With All Letters Uppercase

How to:

The UPPER function takes a source string and returns a string of the same data type with all letters translated to uppercase.


Top of page

x
Syntax: How to Return a String With All Letters Uppercase
UPPER(source_string)

where:

source_string

Alphanumeric

Is the string to convert to uppercase.

The returned string is the same data type and length as the source string.



Example: Converting Letters to Uppercase

In the following request, LCWORD converts LAST_NAME to mixed case. Then UPPER converts the LAST_NAME_MIXED field to uppercase:

DEFINE FILE EMPLOYEE
LAST_NAME_MIXED/A15=LCWORD(15, LAST_NAME, 'A15');
LAST_NAME_UPPER/A15=UPPER(LAST_NAME_MIXED) ;
END
TABLE FILE EMPLOYEE
PRINT LAST_NAME_UPPER AND FIRST_NAME 
BY LAST_NAME_MIXED
WHERE CURR_JOBCODE EQ 'B02' OR 'A17' OR 'B04';
ON TABLE SET PAGE NOPAGE
END

The output is:

  LAST_NAME_MIXED  LAST_NAME_UPPER  FIRST_NAME
  ---------------  ---------------  ----------
  Banning          BANNING          JOHN
  Blackwood        BLACKWOOD        ROSEMARIE
  Cross            CROSS            BARBARA
  Mccoy            MCCOY            JOHN
  Mcknight         MCKNIGHT         ROGER
  Romans           ROMANS           ANTHONY

WebFOCUS