Neoview SQL Reference Manual (R2.5)

LCASE Function
The LCASE function downshifts alphanumeric characters. For non-alphanumeric characters,
LCASE returns the same character. LCASE can appear anywhere in a query where a value can
be used, such as in a select list, an ON clause, a WHERE clause, a HAVING clause, a LIKE
predicate, an expression, or as qualifying a new value in an UPDATE or INSERT statement. The
result returned by the LCASE function is equal to the result returned by the “LOWER Function”
(page 416).
LCASE returns a string of fixed-length or variable-length character data, depending on the data
type of the input string.
LCASE is a Neoview SQL extension.
LCASE (character-expression)
character-expression
is an SQL character value expression that specifies a string of characters to downshift. See
“Character Value Expressions” (page 255).
Considerations for LCASE
For one-to-one mappings for the UCS2 character set, see Appendix A (page 509).
Example of LCASE
Suppose that your CUSTOMER table includes an entry for Hotel Oregon. Select the column
CUSTNAME and return in uppercase and lowercase letters by using the UCASE and LCASE
functions:
SELECT custname,UCASE(custname),LCASE(custname)
FROM sales.customer;
(EXPR) (EXPR) (EXPR)
----------------- ------------------- ------------------
... ... ...
Hotel Oregon HOTEL OREGON hotel oregon
--- 17 row(s) selected.
See “UCASE Function” (page 481).
LCASE Function 411