Book Contents

Book Index

Next Topic

Home

LOWER

LOWER returns a VARCHAR value containing the argument converted to lower case letters.

Syntax

LOWER ( expression )

Semantics

 

expression

(CHAR or VARCHAR) is the string to convert

Examples

> SELECT LOWER('AbCdEfG');

lower

----------

abcdefg

(1 row)