SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
8-87
LCASE Function
LCASE Function
The LCASE function downshifts characters. 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.
LCASE returns a string of either fixed-length or variable-length character data,
depending on the data type of the input string.
You cannot use the LCASE function on KANJI or KSC5601 operands.
LCASE is an SQL/MX extension.
character-expression
is an SQL character value expression that specifies a string of characters to
downshift. See Character Value Expressions on page 6-41.
Examples 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 on page 8-193.
LCASE (character-expression)