Neoview SQL Reference Manual (R2.4)

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 390).
LOWER returns a string of fixed-length or variable-length character data, depending on the data
type of the input string.
LOWER (character-expression)
character-expression
is an SQL character value expression that specifies a string of characters to downshift. See
“Character Value Expressions” (page 240).
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.
The following tables lists all one-to-one mappings for the UCS2 character set.
Table 6-1 One-to-One Uppercase and Titlecase to Lowercase Mappings
L(x)xL(x)xL(x)xL(x)xL(x)xL (x)x
1F631F6B1E5D1E5C0566053603ED03EC017C017B00610041
1F641F6C1E5F1E5E0567053703EF03EE017E017D00620042
1F651F6D1E611E6005680538045104010253018100630043
1F661F6E1E631E6205690539045204020183018200640044
1F671F6F1E651E64056A053A045304030185018400650045
1F801F881E671E66056B053B045404040254018600660046
1F811F891E691E68056C053C045504050188018700670047
1F821F8A1E6B1E6A056D053D045604060256018900680048
1F831F8B1E6D1E6C056E053E045704070257018A00690049
1F841F8C1E6F1E6E056F053F04580408018C018B006A004A
1F851F8D1E711E70057005400459040901DD018E006B004B
1F861F8E1E731E7205710541045A040A0259018F006C004C
1F871F8F1E751E7405720542045B040B025B0190006D004D
1F901F981E771E7605730543045C040C01920191006E004E
1F911F991E791E7805740544045E040E02600193006F004F
LOWER Function 395