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