STR_TO_INT Function

Parameters 1: String

Returns: Integer

Parses a string value into an integer.  If the string is NULL, NULL will be returned.  If the string cannot be parsed, the error action is followed.

The parameter is the string value to be converted to an integer.

Example 1: STR_TO_INT('45') = 45

Example 2: STR_TO_INT(NULL) = NULL

Example 3: STR_TO_INT('Hello') = #ERROR