Progress
Report Builder
User’s Guide


CAPS

Converts lowercase letters (a-z) in a character string expression to the corresponding uppercase letters (A-Z), and returns the resulting character string.

SYNTAX

CAPS ( expression ) 

expression

A constant, field name, or expression that results in a character string.

EXAMPLE

To print the city field from the Customer table in uppercase letters, create the expression:

CAPS(City) 

Sample data:

City		             CAPS(City)
Columbia          COLUMBIA
Jefferson City    JEFFERSON CITY
Kansas City       KANSAS CITY 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095