Difference between revisions of "UPPER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(5 intermediate revisions by 3 users not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[DESCEND()]], [[ISLOWER()]], [[ISUPPER()]], [[LOWER()]], [[PROPER()]], [[STRTOLOWER()]], [[STRTOUPPER()]] | + | [[DESCEND()]], [[ISLOWER()]], [[ISUPPER()]], [[LCASE()]], [[LOWER()]], [[LOWERC()]], [[MID()]], [[PROPER()]], [[SET EXACT]], [[SET STRCOMPARE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[SUBSTR()]], [[UCASE()]], [[UPPERC()]] |
==Description== | ==Description== | ||
− | The UPPER() function converts a character expression <expC> or memo <memofield> to upper case. | + | The UPPER() function converts a character expression <expC> or memo <memofield> to upper 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"> | ||
− | ? upper(" | + | ? upper("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:48, 13 January 2020
Contents
Purpose
Function to convert character expression to upper case
Syntax
UPPER(<expC> | <memofield>)
See Also
DESCEND(), ISLOWER(), ISUPPER(), LCASE(), LOWER(), LOWERC(), MID(), PROPER(), SET EXACT, SET STRCOMPARE, STRTOLOWER(), STRTOUPPER(), SUBSTR(), UCASE(), UPPERC()
Description
The UPPER() function converts a character expression <expC> or memo <memofield> to upper 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
? upper("Lianja") LIANJA