Converts a string to all lower case characters.
This function returns the same datatype as the passed parameter.
LOWER( character_expression )
Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.
> select lower(name) nme from individuals; NME -------------------------------------------------- ms. mary lewis mrs. alice r tolliver mr. sidney k tolliver mrs. jennifer j hopkins mr. charlie hopkins ms. kimberly blue kathleen tucker
See also: