STR2INT Function


Function Type

Predefined function

Syntax

STR2INT( <stringValue> )

Description

Converts a string containing numeric characters to an integer value.

Argument

Description

<stringValue>

String value to be converted.

If non-numeric characters are encountered in the string, the returned value is zero.

Returns

Integer

Examples

This example will return zero.

STR2INT("B123")


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX Data Studio Help