Difference between revisions of "UPPER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert character expression to upper case | Function to convert character expression to upper case | ||
| − | |||
==Syntax== | ==Syntax== | ||
UPPER(<expC> | <memofield>) | UPPER(<expC> | <memofield>) | ||
| − | |||
==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
