Reporting Language > Simplified Conversion Functions > TO_INTEGER: Converting a Character String to an Integer Value

TO_INTEGER: Converting a Character String to an Integer Value

How to:

TO_INTEGER converts a character string that contains a valid number consisting of digits and an optional decimal point to an integer value. If the value contains a decimal point, the value after the decimal point is truncated. If the value does not represent a valid number, zero (0) is returned.

Syntax: How to Convert a Character String to an Integer 

TO_INTEGER(string)

where:

string
Is a character string enclosed in single quotation marks or a character field that represents a number containing digits and an optional decimal point.

Example: Converting a Character String to an Integer Value

WebFOCUS

Feedback