Str2int

sql

FUNCTION Str2int(IN s CHAR(n)) RETURNS INT;

Parameters

s character string containing a Integer type number notation

Description

The Str2Int function converts the number notation in the s string into the int type value and returns that value. Empty string will be converted into NULL. You may also the similar CAST SQL function.

Function value

This function returns an integer value, if the s string has the appropriate notation. Otherwise NULL is returned.

See