Progress
Report Builder
User’s Guide
NUMERIC
Converts character representation of numbers into numeric values (that is, changes the data type from CHARACTER to NUMERIC). This function is the opposite of STRING.
SYNTAX
expression
A character expression (a constant, field name, or expression that results in a character string) that is the character representation of a number.
NOTE
NUMERIC ignores leading spaces.
EXAMPLETo convert the street number portion of the Address field to a numeric value, create a calculated field containing this expression:
Sample data:
To extract the numeric portion of the character field Available, where Available represents the quantity on hand prefixed by the warehouse in which the item is stored, create a calculated field containing this expression:
Sample data:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |