Text based data types: (char, nchar, varchar, nvarchar, etc)

Length: Max number of characters for the column.

Precision: Not useful

Scale: Not useful

Numeric data types: (int, bigint, smallint, tinyint, numeric, decimal, money, etc)

Length: Number of bytes used to store the number.

Precision: Number of digits (not including the â-â for negative numbers)

Scale: Number of digits after the decimal point

Special Numeric: (real, float) (I have only used the numeric, decimal, or money data types to store decimal values)

Length: ?

Precision: ?

Scale: ?

John R Lick

JohnRLick@hotmail.com