Progress
Report Builder
User’s Guide


SPELL-NUMBER

Spells the integer part of a numeric expression. The first character of the resulting character string is uppercase; all other characters are lowercase. The following table lists the possible function results.

If . . .
Then Report Builder returns . . .
The number is negative
A string that begins with the word “Minus”
The integer part of the number is 0
The string “Zero”
The field is blank
The string “Zero”
The string exceeds the maximum string length of 254 characters
A string of question marks

SYNTAX

SPELL-NUMBER ( n ) 

n

The numeric expression representing the number you want to spell.

EXAMPLE

To convert numbers in the Numbers field into their English equivalents, create a calculated field containing the following expression:

SPELL-NUMBER(Numbers) 

Sample data:

Numbers        SPELL-NUMBER(Numbers)
 0.00           Zero
 0.99           Zero
25.01           Twenty-five
-5.99           Minus five 


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