ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    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]

Example 

The following statement returns the value lower case.

SELECT LCASE( 'LOWER CasE' )