Difference between revisions of "UPPER()"

From Lianjapedia
Jump to: navigation, search
 
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 09:48, 13 January 2020

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