Progress
Report Builder
User’s Guide


IS-LETTER

Determines whether the first character of a character expression is any uppercase or lowercase letter. Returns logical YES if true; NO if false.

SYNTAX

IS-LETTER ( string ) 

string

A character expression (a constant, field name, or expression that results in a character value).

EXAMPLE

To determine in which records the character field Prod-code begins with a letter, create a calculated field containing this expression:

IS-LETTER(Prod-code) 

Sample data:

Prod-code    IS-LETTER(Prod-code)
abcd         YES
1bc2         NO
z101         YES 


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