x

LOCASE(length, source_string, output_format)

where:

length

Integer

Is the number of characters in the source_string and output_format. The length must be greater than 0.

source_string

Alphanumeric

Is a string to convert.

output_format

Alphanumeric

Top of page

Example: Converting a Field to Lowercase

LOCASE converts LAST_NAME to lowercase and stores the result in a column with the format A15:

LOCASE(15, LAST_NAME, 'A15')

For SMITH, the result is smith.

For JONES, the result is jones.