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'