UPPER()

From Recital Documentation Wiki
Revision as of 16:56, 28 October 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to convert character expression to upper case


Syntax

UPPER(<expC> | <memofield>)


See Also

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


Description

The UPPER() function converts a character expression <expC> or memo <memofield> 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 Server, Recital