Zero Truncated

21 Oct 2005 4:30 PM

docsql

We have a float (length = 8) field in the table. We want to store values out
ot 4 decimal places. In some cases, where a value ended in 0 or 00, the
places are probably truncated (e.g., 38.9560 = 38.956 or 38.6500 = 38.65). I
would like for us to see the field value out to 4 places. In other words
what should I do so the zeros at the end are not truncated.

Help!!!

21 Oct 2005 5:01 PM

Jerry Spivey

DocSQL,

Recommendation:

Don't use FLOAT. Try DECIMAL instead. May be able to CAST/CONVERT to
DECIMAL to get what you require. Or if doesn't work try (if for display
purposes only) CAST/CONVERT to char/varchar - might require string functions
as well.

HTH

Jerry
Show quote

"docsql" <docsql@noemail.nospam> wrote in message
news:evw%236yl1FHA.3520@TK2MSFTNGP10.phx.gbl...
> We have a float (length = 8) field in the table. We want to store values
> out ot 4 decimal places. In some cases, where a value ended in 0 or 00,
> the places are probably truncated (e.g., 38.9560 = 38.956 or 38.6500 =
> 38.65). I would like for us to see the field value out to 4 places. In
> other words what should I do so the zeros at the end are not truncated.
>
>
>
> Help!!!
>
>