Show all Hide all


This function performs a conversion to the bigint datatype if possible for the given string. If not possible 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: bigint

Returns the converted string if conversion is possible and null otherwise.


@str mandatory varchar(8000)
The string to be converted to a bigint.