Neoview SQL Reference Manual (R2.2)

LOWER Function
• “Considerations for LOWER”
• “Example of LOWER”
The LOWER function downshifts characters. 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.
For UCS2, 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.
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 208).
Considerations for LOWER
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
1F921F9A1E7B1E7A05750545045F040F0263019400700050
354 SQL Functions and Expressions