LOWER
Takes a string value and returns a VARCHAR value converted to lowercase.
Behavior Type
Syntax
LOWER ( expression )
Arguments
expression |
CHAR or VARCHAR string to convert, where the string width is ≤ 65000 octets. In practice, expression should not exceed 32,500 octets. LOWER does not use the locale's collation setting—for example, Note also that if expression is a table column, LOWER calculates its size from the column's defined width, and not from the column data. If the column width is greater than VARCHAR(32500), Vertica returns an error. |
Examples
=> SELECT LOWER('AbCdEfG'); LOWER --------- abcdefg (1 row)
=> SELECT LOWER('The Bat In The Hat'); LOWER -------------------- the bat in the hat (1 row)
=> SELECT LOWER('ÉTUDIANT'); LOWER ---------- étudiant (1 row)