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