LCASE function [String]

Function

Converts all characters in a string to lower case.

Syntax

LCASE ( string-expression )

Parameters

string-expression The string to be converted to lower case.

Example

The following statement returns the value lower case.

SELECT LCASE( 'LOWER CasE' ) FROM iq_dummy

Standards and compatibility

SQL/92 Vendor extension.

Sybase LCASE is not supported in Adaptive Server Enterprise; you can use LOWER to get the same functionality.

See also

“LOWER function [String]”

“UCASE function [String]”

“UPPER function [String]”