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
EXAMPLE
This example illustrates the LCASE function:
NOTES
- The argument to the function must be of type CHARACTER.
- The result is of type CHARACTER.
- If the argument expression evaluates to null, the result is null.
- A
char_expression
and the result may contain multi-byte characters. The lowercase conversion is determined by the case table in theconvmap
file. The default case table is BASIC.COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |