IsNumeric Property

SQL-DMO

IsNumeric Property

The IsNumeric property is TRUE if the system data type referenced is an exact, numeric data type.

Applies To

SystemDatatype Object

Syntax

object.IsNumeric

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetIsNumeric(LPBOOL pRetVal);

Remarks

Exact numeric data types are scaled integer values represented as strings. When defining a column using an exact numeric data type, precision and scale are specified, as in decimal(12, 4).