do not cut decimal places

Hi,

following problem (oracle8): I want to insert a value with precision (#.##) in a number(10,2) column. It works but the values which end with .0 or .00 are always truncated:

100.00 --> 100
1000.0 --> 1000

Is there a way to prevent this and to show the decimal places although they are 0?

Thanks,

-marek Received on Wed Jul 02 2003 - 04:16:00 CDT