LOCASE: Converting Text to Lowercase

How to:

The LOCASE function converts alphanumeric text to lowercase.


Top of page

x
Syntax: How to Convert Text to Lowercase
LOCASE(length, source_string, output)

where:

length

Integer

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

source_string

Alphanumeric

Is the character string to convert.

output

Alphanumeric



Example: Converting a String 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.


iWay Software