Neoview SQL Reference Manual (R2.5)

LOWER Function
• “Considerations for LOWER”
• “Example of LOWER”
The LOWER function downshifts alphanumeric characters. For non-alphanumeric characters,
LOWER returns the same character. LOWER 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 LOWER function is equal to the result returned by the “LCASE Function”
(page 411).
LOWER returns a string of fixed-length or variable-length character data, depending on the data
type of the input string. For information about the one-to-one mappings for the UCS2 character
set, see Appendix A (page 509).
LOWER (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 LOWER
For a UCS2 character expression, the LOWER function downshifts all the uppercase or title case
characters in a given string to lowercase and returns a character string with the same data type
and character set as the argument.
A lower case character is a character that has the “alphabetic” property in Unicode Standard 2
whose Unicode name includes lower. An uppercase character is a character that has the
“alphabetic” property in the Unicode Standard 2 and whose Unicode name includes upper. A
title case character is a character that has the Unicode “alphabetic” property and whose Unicode
name includes title.
Example of LOWER
Suppose that your CUSTOMER table includes an entry for Hotel Oregon. Select the column
CUSTNAME and return the result in uppercase and lowercase letters by using the UPPER and
LOWER functions:
SELECT custname,UPPER(custname),LOWER(custname)
FROM sales.customer;
(EXPR) (EXPR) (EXPR)
----------------- ------------------- ------------------
... ... ...
Hotel Oregon HOTEL OREGON hotel oregon
--- 17 row(s) selected.
See “UPPER Function” (page 482).
416 SQL Functions and Expressions