Show all Hide all


This function takes a string and attempts a conversion to the int datatype after having first stripped away (removed) all characters that are not digits. If the string contain no digits at all, or if it would overflow an int, then a value of null is returned.

The special case of a null-string will give a return value of null.

Type: Scalar function
Area of use: General use

Return value: int

The integer value stripped and converted from the given string.


@str mandatory varchar(8000)
The string to be stripped and converted.