ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

LOWER function [String]

Function 

Converts all characters in a string to lower case.

Syntax 

LOWER ( string-expression )

Parameters 

string-expression    The string to be converted.

Standards and compatibility 

• SQL/92    SQL/92 compatible.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

LCASE function [String]

UCASE function [String]

UPPER function [String]

Example 

The following statement returns the value lower case.

SELECT LOWER( 'LOWER CasE' )