<< IIF() | FB 2.0 Language Reference | NULLIF() >>

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)

Example

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

See also:
CAST()
UPPER()
Firebird Null Guide: Internal functions and directives
Firebird 2.0.4 Release Notes: New features for text data

back to top of page
<< IIF() | FB 2.0 Language Reference | NULLIF() >>