LCASE or LOWER

LCASE or LOWER returns a string in which all alphabetic characters in the input character expression have been converted to lowercase.

LOWER and LCASE follow the database locale.

Syntax

LCASE or LOWER ( CharacterExpression ) 

CharacterExpression

A  LONG VARCHAR data type, or any built-in type that is implicitly converted to a string (but not a bit expression).

Results

The data type of the result is as follows:

  • If the CharacterExpression evaluates to NULL, this function returns NULL.
  • If the CharacterExpression is of type  CHAR.
  • If the CharacterExpression is of type  LONG VARCHAR.
  • Otherwise, the return type is  VARCHAR.

The length and maximum length of the returned value are the same as the length and maximum length of the parameter.

Examples

splice> SELECT LCASE(DisplayName)
   FROM Players
   WHERE ID < 11;
1
------------------------
buddy painter
billy bopper
john purser
bob cranker
mitch duffer
norman aikman
alex paramour
harry pennello
greg brown
jason minman

10 rows selected

See Also