I have a SQL Express db with a table field defined as data type
decimal(18,0).

When I type in .785 in the table field it rounds it to 1.

Any ideas why????

Why do I have to use float? Doesnt decimal indicate that you can use a
decimal?

"Cirene" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a SQL Express db with a table field defined as data type
>decimal(18,0).
>
> When I type in .785 in the table field it rounds it to 1.
>
> Any ideas why????
>

Cirene,

Isn't your specification saying that you want 0 digits to the right of the
decimal point?

Kerry Moorman


"Cirene" wrote:

> I have a SQL Express db with a table field defined as data type
> decimal(18,0).
>
> When I type in .785 in the table field it rounds it to 1.
>
> Any ideas why????
>
>
>