LOWER: Returning a String With All Letters Lowercase

How to:

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


Top of page

x
Syntax: How to Return a String With All Letters Lowercase
LOWER(string)

where:

string

Alphanumeric

Is the string to convert to lowercase.

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



Example: Converting a String to Lowercase

In the following request against the EMPLOYEE data source, LOWER converts the LAST_NAME field to lowercase and stores the result in LOWER_NAME:

TABLE FILE EMPLOYEE
PRINT LAST_NAME AND COMPUTE
LOWER_NAME/A15 = LOWER(LAST_NAME);
ON TABLE SET PAGE NOPAGE
END

The output is:

  LAST_NAME        LOWER_NAME
  ---------        ----------
  STEVENS          stevens
  SMITH            smith
  JONES            jones
  SMITH            smith
  BANNING          banning
  IRVING           irving
  ROMANS           romans
  MCCOY            mccoy
  BLACKWOOD        blackwood
  MCKNIGHT         mcknight
  GREENSPAN        greenspan
  CROSS            cross

WebFOCUS