LOWER()

The LOWER() function converts mark characters in a string to the next lower level mark.

Format

LOWER(string)

where

string

evaluates to the string in which mark characters are to be converted.

The LOWER() function replaces mark characters according to the following table:

Original

Replacement

Item mark

Field mark

Value mark

Subvalue mark

Text mark

Text mark (unchanged)

Migration Note

Note that the behaviour in some other multivalue products may not be identical with regard to the effect of lowering a text mark.

Example

READLIST LIST THEN REC<4> = LOWER(LIST)

This statement reads active select list zero to LIST and then saves it in field 4 of REC. Because a select list contains field marks, the LOWER() function is used to demote each mark character to the next lowest mark.