Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateInternal functions → LOWER()
Firebird Home Firebird Home Prev: LOG10()Firebird Documentation IndexUp: Internal functionsNext: LPAD()

LOWER()

Available in: DSQL, ESQL, PSQL

Added in: 2.0

Changed in: 2.1

Description: Returns the lower-case equivalent of the input string. The exact result depends on the character set. With ASCII or NONE for instance, only ASCII characters are lowercased; with OCTETS, the entire string is returned unchanged. Since Firebird 2.1 this function also fully supports text BLOBs of any length and character set.

Result type: (VAR)CHAR or BLOB

Syntax: 

LOWER (str)

Note

Because LOWER is a reserved word, the internal function wil take precedence even if the external function by that name has also been declared. To call the (inferior!) external function, use double-quotes and the exact capitalisation, as in "LOWER"(str).

Example: 

select Sheriff from Towns
  where lower(Name) = 'cooper''s valley'

See also: UPPER

Prev: LOG10()Firebird Documentation IndexUp: Internal functionsNext: LPAD()
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateInternal functions → LOWER()