Numeric Data Type

  • Article

Use Numeric data to indicate magnitude. Numeric values contain digits from 0 to 9, and, optionally, a sign and a decimal point. For more information about the specifications for this type, see the tables of Data and Field Types.

Visual FoxPro also supports hexadecimal values for numeric data. For example, the decimal value 255 can be represented as 0xFF.

In Numeric fields, you determine the length of the decimal portion at design time when you create the field. The length of the decimal portion is part of the total length. For example, if you specify a length of 6 for a numeric field and a decimal setting of 4, the field can store values up to 9.9999.

See Also

CREATE TABLE - SQL Command | Numeric Expression Creation | Data and Field Types | Numeric Operators