lower

Description

Returns the lowercase equivalent of the specified expression.

Syntax

lower(char_expr | uchar_expr)

Parameters

char_expr

is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.

uchar_expr

is a character-type column name, variable, or constant expression of unichar or univarchar type.

Examples

Example 1

select lower(city) from publishers
-------------------- 
boston
washington
berkeley

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute lower.

See also

Function upper