lower

Converts uppercase characters to lowercase, returning a character value.

Syntax

lower(char_expr | uchar_expr)

Parameters

Examples

Usage

  • lower is the inverse of upper.

  • If char_expr or uchar_expr is NULL, returns NULL.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute lower.

Related reference
upper