ADMIN_IsNumeric

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Scalar function

This function can be used to validate if a conversion to the numeric (or decimal) datatype is possible for a given string.

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

Return value: bit

Returns 1 if conversion is possible and 0 otherwise.

Parameters

@str mandatory varchar(8000)