Difference between revisions of "UPPER()"

From Recital Documentation Wiki
Jump to: navigation, search
(No difference)

Revision as of 14:36, 20 March 2009

UPPER()

Class

String Data


Purpose

Function to convert character expression to upper case


Syntax

UPPER(<expC>)


See Also

LOWER(), ISUPPER(), ISLOWER(), DESCEND(), PROPER()


Description

The UPPER() function converts a character expression, <expC>, to upper case. This function is particularly useful with index expressions, as when the FIND key is pressed in forms, a search string typed in upper case will match both upper and lower case characters stored in the table.


Example

? upper("Recital")
RECITAL


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer