Difference between revisions of "UPPER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[DESCEND()]], [[ISLOWER()]], [[ISUPPER()]], [[LCASE()]], [[LOWER()]], [[MID()]], [[PROPER()]], [[SET EXACT]], [[SET STRCOMPARE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[SUBSTR()]], [[UCASE()]] | + | [[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== |
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