lower

Converts uppercase characters to lowercase, returning a character value.

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 – Converts the cities in the publishers database to lowercase:
```
select lower(city) from publishers
```
```
-------------------- 
boston
washington
berkeley
```

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.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com