Difference between revisions of "LOWER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(6 intermediate revisions by 4 users not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ISLOWER()]], [[ISUPPER()]], [[PROPER()]], [[SET STRESCAPE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]] | + | [[ISLOWER()]], [[ISUPPER()]], [[LCASE()]], [[MID()]], [[PROPER()]], [[SET EXACT]], [[SET STRCOMPARE]], [[SET STRESCAPE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[SUBSTR()]], [[TRANSFORM()]], [[UCASE()]], [[UPPER()]] |
==Description== | ==Description== | ||
− | The LOWER() function converts the characters in the character expression <expC> or memo <memofield> to lower case. | + | The LOWER() function converts the characters in the character expression <expC> or memo <memofield> to lower case. |
+ | |||
+ | From Lianja v5.2 the [[UPPERC()]] function can be used to convert utf-8 character expressions to upper case and the [[LOWERC()]] function to convert utf-8 character expressions to lower case. | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | ? lower(" | + | ? lower("Lianja") |
− | + | lianja | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
</code> | </code> | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Latest revision as of 10:49, 13 January 2020
Contents
Purpose
Function to convert characters to lower case
Syntax
LOWER(<expC> | <memofield>)
See Also
ISLOWER(), ISUPPER(), LCASE(), MID(), PROPER(), SET EXACT, SET STRCOMPARE, SET STRESCAPE, STRTOLOWER(), STRTOUPPER(), STRTRAN(), SUBSTR(), TRANSFORM(), UCASE(), UPPER()
Description
The LOWER() function converts the characters in the character expression <expC> or memo <memofield> to lower case.
From Lianja v5.2 the UPPERC() function can be used to convert utf-8 character expressions to upper case and the LOWERC() function to convert utf-8 character expressions to lower case.
Example
? lower("Lianja") lianja