LOWER()

Tip

Find a more recent version at Firebird 5.0 Language Reference: LOWER()

Available in: DSQL, ESQL, PSQL

Added in: 2.0

Description: Returns the lower-case equivalent of the input string. This function also correctly lowercases non-ASCII characters, even if the default (binary) collation is used. The character set must be appropriate though: with ASCII or NONE for instance, only ASCII characters are lowercased; with OCTETS, the entire string is returned unchanged.

Result type: (VAR)CHAR

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'