Progress
Report Builder
User’s Guide


INTEGER

Extracts the integer part of a numeric value.

SYNTAX

INTEGER ( expression ) 

expression

A constant, field name, or expression whose value is numeric.

NOTE

In the Progress 4GL, the INTEGER function accepts strings. However, in Report Builder, INTEGER only accepts numeric values. To convert strings, use the NUMERIC function.

EXAMPLE

To convert the numbers in the Numbers table to integers, create a calculated field containing this expression:

INTEGER(Numbers) 

Sample data:

Numbers      INTEGER(Numbers)
 14.345            14
 45.543            45
-62.987           -62 


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