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)

Important: If the external function LOWER is declared in your database, it will override the internal function. To make the internal function available, DROP or ALTER the external function (UDF).

Example

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