8.3.7. LOWER()

Available in

DSQL, ESQL, PSQL

Possible name conflict

YES → Read details below

Syntax

  1. LOWER (string)
Table 129. LOWER Function ParameterS
ParameterDescription

string

An expression of a string type

Result type

(VAR)CHAR or BLOB

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.

Name Clash

Because LOWER is a reserved word, the internal function will 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”(string).

Example

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

See also

UPPER()