LOWCASE Function

Converts all letters in a character expression to lowercase.

Category: Character
Alias: LOWER
Returned data type: VARCHAR, NVARCHAR

Syntax

LOWCASE(expression)

Arguments

expression

specifies any valid expression that evaluates to a character string.

Requirement Literal character expressions must be enclosed in single quotation marks.
Data type CHAR, NCHAR
See <sql-expression>
FedSQL Expressions

Details

The LOWCASE function copies a character expression, converts all uppercase letters to lowercase letters, and returns the altered value as a result.

Comparisons

The UPCASE function converts all letters in an argument to uppercase letters. The LOWCASE function converts all letters in an argument to lowercase letters.

Example

The following statement illustrates the LOWCASE function:
Statements
Results
select lowcase('INTRODUCTION');
introduction

See Also

Functions:
Last updated: February 23, 2017