How to: |
The LOCASE function converts alphanumeric text to lowercase.
LOCASE(length, source_string, output)
where:
Integer
Is the number of characters in source_string and output. The length must be greater than 0 .
Alphanumeric
Is the character string to convert.
Alphanumeric
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 |