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

Syntax

LCASE( string-expression )

Parameters

Returns

CHAR

NCHAR

LONG VARCHAR

VARCHAR

NVARCHAR

Remarks

The LCASE function is similar to the LOWER function.

See also

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

Standards and compatibility

Example

The following statement returns the value chocolate.

SELECT LCASE( 'ChoCOlatE' );