LOWER()

Procedural SQL (PSQL) StatementsAggregate Functions

`LOWER()`

Converts a string to lowercase

Result type

(VAR)CHAR, (VAR)BINARY or BLOB

Syntax

LOWER (string)

Table 1. `LOWER` Function ParameterS
Parameter	Description
string	An expression of a string type

Returns the lowercase 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 character set OCTETS/(VAR)BINARY, the entire string is returned unchanged.

`LOWER` Examples

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

LOWER()

LOWER()

LOWER Examples

`LOWER()`

`LOWER` Examples