Subject | Float data type |
---|---|

Author | Stevio |

Post date | 2002-06-21T14:55:36Z |

I am going to create a new table and I want to include a datatype that is

similar to a float.

The datatype must be numerical and must have 3 digits before the decimal

point and a maximum of 6.

e.g.123.456789

Please note that the 3 digits before the decimal point are a must, even when

they are 0. e.g. 004.232 but the digits after the decimal point, and the

decimal point itself, are optional.

Anyone got any suggestions?

Thanks,

Stephen

similar to a float.

The datatype must be numerical and must have 3 digits before the decimal

point and a maximum of 6.

e.g.123.456789

Please note that the 3 digits before the decimal point are a must, even when

they are 0. e.g. 004.232 but the digits after the decimal point, and the

decimal point itself, are optional.

Anyone got any suggestions?

Thanks,

Stephen