How to keep the .0 in number fields? 1

[squirleegirl]

I know this is probably a stupid question, but what data type will allow me to use decimals even on whole numbers?

I have some users that want will sometimes enter decimal numbers in, but if the number they enter is a whole number, they still want to see the .0 after the number.

Which data type must I use? I just can't figure it out.

 

[SQLSister]

No numeric dataype will allow that. You need to format it at the user interface.

Questions about posting. See faq183-874

 

[squirleegirl]

Duh! I should have known that. Thanks for the quick reply - the light bulb just went off! Sorry, I'm blonde =-)