<< LOG10() | FB 2.1 Language Reference | LPAD() >>


Available in: DSQL, ESQL, PSQL

Added in: 2.0

Changed in: 2.1


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


 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).


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

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

back to top of page
<< LOG10() | FB 2.1 Language Reference | LPAD() >>