Database design

[Jolten]

I need to add a field to a table in my database. The insert into this field will be a decimal number such as 8.1234. I'm not sure which type of field would best handle this. Would an INT field be good?

any suggestions?

[filburt1]

INT would not work because it will truncate the decimal portion. Instead, try (IIRC) FLOAT.

[Marco van Herwaarden]

An INT could be the right choice, it depend a bit on the size of the number you want to store and maybe the precision.

[Jolten]

Thanks Filburt... that's exactly why I'm asking before doing this.

I appreciate the assist.