DataMigrator/Reporting Server > 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:

Convert a Character String to an Integer

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

TO_INTEGER converts the character string '56.78' to an integer.

TO_INTEGER('56.78')

The result is 56.

	WebFOCUS

Feedback