Progress
SQL-92
Guide and Reference


LCASE Function

Returns the result of the argument character expression after converting all the characters to lowercase. LCASE is the same as LOWER but provides ODBC-compatible syntax.

SYNTAX

LCASE ( char_expression ) 

EXAMPLE

This example illustrates the LCASE function:

SELECT *
    FROM customer
    WHERE LCASE (last_name) = ’smith’ ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095