String functions

String functions

• extract substrings (SUBSTRING)

• transliterate alphanumeric strings to national strings or vice versa (TRANSLATE)

• transcode national strings from UTFE to UTF-16 or vice versa (TRANSLATE)

• remove leading or trailing characters of strings (TRIM)

• convert uppercase letters to lowercase letters or lowercase letters to uppercase letters (LOWER, UPPER)

• convert a value of any data type to the internal presentation (as an alphanumeric string or in hexadecimal format) and vice versa (HEX_OF_VALUE, VALUE_OF_HEX, REP_OF_VALUE, VALUE_OF_REP)

• for national strings, supply the collation element in accordance with the Default Unicode Translation Table (COLLATE)

• convert national strings to normal form (NORMALIZE)