Converts all characters in a string to lowercase. This function is identical the LCASE function.

Syntax

LOWER( string-expression )

Parameters

Returns

CHAR

NCHAR

LONG VARCHAR

VARCHAR

NVARCHAR

Remarks

The LCASE function is identical to the LOWER function.

See also

• LCASE function [String]
• UCASE function [String]
• UPPER function [String]
• String functions

Standards and compatibility

Example

The following statement returns the value chocolate.

SELECT LOWER( 'chOCOLate' );