float formating with xx.00

On Thursday 03 Jul 2003 8:42 pm, Mark wrote:

Hy,

I am trying to enter 19.00 in a float field... no error but the data
(select) is showing 19 without the "trailing" zeros... But for format and
standard presentation of money, I need to keep any last zero digit.

How can I do this? I run version 7.1x
Thanks!

Consider using the numeric type, or you can cast to it for output.

select 19::numeric(9,2);
numeric
---------
19.00

--
Richard Huxton